Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run userForm only when opened manually
I have a excel sheet that I need to have a usrForm run but only when it is
opened by hand. I will be calling this XLS from a VB program and that shouldn't run it. What events should I use to trigger this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run userForm only when opened manually
Use this sub in a normal module
Alt-F11 InsertModule in the menubar paste the sub there Alt-Q to go back to Excel Sub Auto_Open() Userform1.show End Sub This will not run if you open the workbook with code If you place the code in the workbook open event it will run when you open the workbook with code. -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl ";-)" wrote in message ... I have a excel sheet that I need to have a usrForm run but only when it is opened by hand. I will be calling this XLS from a VB program and that shouldn't run it. What events should I use to trigger this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run userForm only when opened manually
Thanks.
This will work for my needs. "Ron de Bruin" wrote in message ... Use this sub in a normal module Alt-F11 InsertModule in the menubar paste the sub there Alt-Q to go back to Excel Sub Auto_Open() Userform1.show End Sub This will not run if you open the workbook with code If you place the code in the workbook open event it will run when you open the workbook with code. -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl ";-)" wrote in message ... I have a excel sheet that I need to have a usrForm run but only when it is opened by hand. I will be calling this XLS from a VB program and that shouldn't run it. What events should I use to trigger this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I manually sort the legend key? | Charts and Charting in Excel | |||
Userform won't show when file re-opened | Excel Discussion (Misc queries) | |||
Currency Format on UserForm when opened! | Excel Discussion (Misc queries) | |||
Does this have to be done manually? | Excel Discussion (Misc queries) | |||
Can macro/userform run depending on HOW workbook is opened? | Excel Discussion (Misc queries) |