Run macro automatically

[Guest]

How to program VB so that when open the Excel work book it run the macro
automatically without hit tool/ macro/run
Thnks
Daniel

 

[Guest]

you would use the workbook_open event. As long as macros are not disabled
either by the security setting or manually by the user, it would run on
opening.

http://www.cpearson.com/excel/events.htm
describes the various events available to you.

 

[Guest]

'Paste this into the Thisworkbook Mod
'and Replace Run "Macro"
'To Run "MyMacroName"
Private Sub Workbook_Open()
Run "Macro"
End Sub