C clui Dec 2, 2003 #1 How do I let a procedure run when opening a workbook? I already hav that procedure written named as "RunOnOpen". Thanks
How do I let a procedure run when opening a workbook? I already hav that procedure written named as "RunOnOpen". Thanks
B Bob Phillips Dec 2, 2003 #2 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 said: How do I let a procedure run when opening a workbook? I already have that procedure written named as "RunOnOpen". Thanks! ------------------------------------------------ ~~Now Available: Financial Statements.xls, a step by step guide to Click to expand... creating financial statements
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 said: How do I let a procedure run when opening a workbook? I already have that procedure written named as "RunOnOpen". Thanks! ------------------------------------------------ ~~Now Available: Financial Statements.xls, a step by step guide to Click to expand... creating financial statements
