Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run a procedure when opening a workbook
How do I let a procedure run when opening a workbook? I already hav that procedure written named as "RunOnOpen". Thanks ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
run a procedure when opening a workbook
Put the code in the workbook open event
Private Sub Workbook_Open() RunOnOpen End Sub Put this in ThisWorkbook code mmodule. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "clui" wrote in message ... How do I let a procedure run when opening a workbook? I already have that procedure written named as "RunOnOpen". Thanks! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop blank workbook from opening when opening an existing | Excel Discussion (Misc queries) | |||
How to run external workbook function/procedure? | Excel Discussion (Misc queries) | |||
Help with workbook procedure | Excel Worksheet Functions | |||
Workbook.Open Event Procedure not firing | Excel Programming |