| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create startup boxes that once answered appear in a form | Excel Worksheet Functions | |||
| Custom User Form At Startup | Excel Discussion (Misc queries) | |||
| Displaying data in bar form on a line chart | Charts and Charting in Excel | |||
| Displaying Cell Data on a Form | Excel Programming | |||
| Displaying part of a sheet on a user form | Excel Programming | |||
Linear Mode
