How can I set up a Macro to automatically run when I open a speci.

[Guest]

How can I set up a Macro to automatically run when I open a specific Excel
file?

 

[Nick Hodge]

Rick

Still supported. (In a standard module)

Sub Auto_Open()
'Code here
End Sub

Preferred (XL97 up), use the workbook_Open() event, thus

Private Sub Workbook_Open()
'Code goes here
End Sub

The latter will fire even if the workbook is open through code

For an explanation of different module types and how to implement, go to

http://www.nickhodge.co.uk/vba/vbaimplement.htm

BTW, where are you posting from, I'm very interested as we seem to have a
huge number of posts recently that have had the subject line truncated? It
looks like the web interface to the newsgroups at Microsoft, but if you
could send the URL it would be great

Thanks

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)