Dear people,
Can someone tell me how to get a macro to run uponj opening an excel file?
Thanks,
George

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

George Davis wrote:

Dear people,
Can someone tell me how to get a macro to run uponj opening an excel file?
Thanks,
George


--

Dave Peterson

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


---
Regards,
Norman



"George Davis" wrote in message
link.net...
Dear people,
Can someone tell me how to get a macro to run uponj opening an excel
file?
Thanks,
George