| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Autolaunching the form box in Excel
I want to be able to open a data sheet and have the form box launch
automatically. Can anyone help me with this? Thank you very much! |
|
#2
|
|||
|
|||
|
Anna,
Try something like the following: Sub Auto_Open() Worksheets("Sheet1").Select Worksheets("Sheet1").ShowDataForm End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Anna" wrote in message ... I want to be able to open a data sheet and have the form box launch automatically. Can anyone help me with this? Thank you very much! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
| VB Automation is Whacking out my Excel Environment | Excel Discussion (Misc queries) | |||
| Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) | |||
| Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Linear Mode
