Displaying form on startup?
 

Hi all, I have created a form and now I would like it to appear as soon as
Excel starts up. If its possible I would like it to appear as a standalone
program (if that makes sense)

TIA,
PE1

Displaying form on startup?
 

Hi
for starting it directly after opening put your code in the
workbook_open event procedure of your workbook

--
Regards
Frank Kabel
Frankfurt, Germany

"PEno1" schrieb im Newsbeitrag
...
Hi all, I have created a form and now I would like it to appear as
soon as
Excel starts up. If its possible I would like it to appear as a
standalone
program (if that makes sense)

TIA,
PE1

Displaying form on startup?
 

Try this,


Private Sub Workbook_Open()
Application.Visible = False
UserForm1.Show
Application.Visible = True
End Sub


Regards,
Vic Eldridge


"PEno1" wrote in message ...
Hi all, I have created a form and now I would like it to appear as soon as
Excel starts up. If its possible I would like it to appear as a standalone
program (if that makes sense)

TIA,
PE1