Regouin
03-23-2005, 08:25 AM
Ok, I have another problem.
I have a workbook which opens a userform upon opening, what I want it to do is to entirely hide the excel application when the userform is active. The Excel sheet can appear again once the userform is closed, I tried it with a similar action to how you hide Word when you call it from excel, but that doesnt seem to work. And I dont know if it is possible to show the userform but hide the rest of excel.
tia
frank
Private Sub UserForm_Activate()
Dim AppExcel As Excel.Application
Dim i As Long
Dim fsoObj As Object
Dim Fs As Object
Dim week As Long
Set fsoObj = CreateObject("Scripting.FileSystemObject")
Set Fs = CreateObject("Scripting.FileSystemObject")
Set AppExcel = CreateObject("excel.Application")
AppExcel.Visible = False
Set AppExcel = Nothing
Worksheets("hoofd").Activate
End Sub
I have a workbook which opens a userform upon opening, what I want it to do is to entirely hide the excel application when the userform is active. The Excel sheet can appear again once the userform is closed, I tried it with a similar action to how you hide Word when you call it from excel, but that doesnt seem to work. And I dont know if it is possible to show the userform but hide the rest of excel.
tia
frank
Private Sub UserForm_Activate()
Dim AppExcel As Excel.Application
Dim i As Long
Dim fsoObj As Object
Dim Fs As Object
Dim week As Long
Set fsoObj = CreateObject("Scripting.FileSystemObject")
Set Fs = CreateObject("Scripting.FileSystemObject")
Set AppExcel = CreateObject("excel.Application")
AppExcel.Visible = False
Set AppExcel = Nothing
Worksheets("hoofd").Activate
End Sub