How do you get a macro to automatically execute when you open a workbook?

Hi
tow ways:
1. Rename your macro to Auto_Open()
2. Put your code in the workbook_open() event

--
Regards
Frank Kabel
Frankfurt, Germany

"RDCLARK" schrieb im Newsbeitrag
...
How do you get a macro to automatically execute when you open a
workbook?

Hi
Assuming you've got XL97 or above, double click on the ThisWorkbook object
(for the workbook concerned) in VBE project window to create a module. In
the module window select Workbook and Open from the drop-down lists. The
following
code will automatically be generated:

Private Sub Workbook_Open()

End Sub

Insert the code you want and save.

Regards

Paul





"RDCLARK" wrote in message
...
How do you get a macro to automatically execute when you open a workbook?

Use the workbook_Open event

see Chip Pearson's page on events

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

--
Regards,
Tom Ogilvy

"RDCLARK" wrote in message
...
How do you get a macro to automatically execute when you open a workbook?