Auto macro

[George Davis]

Dear people,
Can someone tell me how to get a macro to run uponj opening an excel file?
Thanks,
George
(e-mail address removed)

 

[Dave Peterson]

Name it Auto_Open() and put it in a General module.

 

[Norman Jones]

Hi George,

Call the macro from the workbook's open event, e.g:

'===========>>
Private Sub Workbook_Open
Call myMacro
End Sub
'<<===========

This code should be placed in the workbook's ThisWorkbook module - not in a
standard module and not in a sheet module.

Alternatively, name the macro Auto_Open and place it in a standard module.


For mor information on event procedures, see Chip Pearson atL

http://www.cpearson.com/excel/events.htm