Auto run

[sanjna000]

Hi,

I need to open up the main form in my vba application once i double click on the excel application. I mean the excel application should not open up the excel spreadsheet instead it should open up the form. Can anyone help me with that?

Thanks a lot for u r help in advance.
Sanjna...

 

[PHV]

In the workbook open event procedure minimize excel and show the UserForm.

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

 

[sanjna000]

Hi PH,
Where can i find workbook open event procedure? I am very new to VBA and i know nothing. sorry for bothering you.

 

[sanjna000]

Hi PH,
I was able to do it as u suggested. Thanks a lot for u r help!

Sanju...

 

[sanjna000]

PH,
Only prob is even the form is minimised since i minimise the application before calling the show event. How can i give a normal window state to the form.

Sanjna