Displaying form on startup?

  • Thread starter Thread starter PEno1
  • Start date Start date
P

PEno1

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
 
Hi
for starting it directly after opening put your code in the
workbook_open event procedure of your workbook
 
Try this,


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


Regards,
Vic Eldridge
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing Form 2
Check Boxes? 2
Unwanted workbooks on startup 2
Starting a 'floating' form once a spreadsheet is open 1
Launching Standalone Program from within Excel. 4
Macro required 2
Using Multiple Monitors with Excel Spreadsheet with VBA Code 1
Export as pdf form to ipad 2

Back
Top