| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Load form when workbook opens
Its been a while since I've worked in excel. How do I automatically
load a form when the workbook opens? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Load form when workbook opens
Right-click on the Excel logo at left end of menu bar.
Select "View Code". Copy/paste this into that module. Private Sub Workbook_Open() Userform.Show End Sub Gord Dibben MS Excel MVP On 18 Jul 2006 17:17:23 -0700, wrote: Its been a while since I've worked in excel. How do I automatically load a form when the workbook opens? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Load form when workbook opens
Thanks works great |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge Excel data into specific form areas in a Word Doc | Excel Discussion (Misc queries) | |||
| Excel opens saved workbook without tabs or scroll bars showing? | Excel Worksheet Functions | |||
| Personal workbook opens when Excel opens | Excel Discussion (Misc queries) | |||
| Unprotect Workbook | Excel Discussion (Misc queries) | |||
| Workbook opens twice | Excel Discussion (Misc queries) | |||
Linear Mode
