Form Open

[sanjna000]

Hi There,
i need to open up the main form when i double click on my work book. The code i used is as follows:

Application.WindowState = xlMinimized
Frm_Main.Show

But the problem is once i double click on the work book the whole application is minimized including the form. Is there anyway that i can show the form in a normal window state?

Really need u r help!

Thanks,
Sanjna...

 

[BrainB]

Could go the whole hog :-

Sub test()
    Application.Visible = False
    UserForm1.Show
    Unload UserForm1
    Application.Visible = True
End Sub

Regards
BrianB
Use CupOfCoffee to speed up all windows applications.
It is easy until you know how.
================================

 

[sanjna000]

Thanks Brian
It works brill

 

[PHV]

Application.Visible = False
Hopefully the VBA code will NEVER raise any error ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244