PDA

View Full Version : Solved: Hide Excel application and show just a Userform



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

Killian
03-23-2005, 08:38 AM
Application.Visible = False/True on a UserForm Initialise and Terminate events works for this (XL2003)

Regouin
03-23-2005, 08:39 AM
You're on a roll here today, works perfectly.

thanx
Frank

sheeeng
05-29-2005, 08:18 PM
Can it work on Excel 2002 (XP) ?

sheeeng
05-29-2005, 08:28 PM
Can it work on Excel 2002 (XP) ?

It's works on Excel 2002 (XP).
Thanks a lot. This forum really help me out.

:clap: :clap: :clap: :clap: :clap: :clap: :clap: :clap: :clap: :clap: :clap: :clap: