| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Always open Excel file with Userform
I want to load the Userform first when ever I open a particular Excel file
which is saved with that specific Userform? Pls Help Santhosh Kuwait |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Always open Excel file with Userform
Hi,
Load the form from a Workbook_Open event. This is found in the ThisWorkbook class module.... Private Sub Workbook_Open() Load UserForm1 UserForm1.Show End Sub Hth, OJ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Always open Excel file with Userform
Thankyou So much
"OJ" wrote: Hi, Load the form from a Workbook_Open event. This is found in the ThisWorkbook class module.... Private Sub Workbook_Open() Load UserForm1 UserForm1.Show End Sub Hth, OJ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you make a userform open automatically when you open excel? | Excel Worksheet Functions | |||
| How to keep UserForm open at all times while excel is running | Excel Discussion (Misc queries) | |||
| excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
| In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
| How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel | |||
![Santhosh Mani[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
