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

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