run a procedure when opening a workbook

C

clui

How do I let a procedure run when opening a workbook? I already hav
that procedure written named as "RunOnOpen". Thanks
 
B

Bob Phillips

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!
Click to expand...
creating financial statements
 
Top