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