Run macro automatically
 

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

Run macro automatically
 

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.

--
Regards,
Tom Ogilvy


"Daniel" wrote:

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

Run macro automatically
 

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

"Daniel" wrote:

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