Excel auto-start macro

[Guest]

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

 

[Frank Kabel]

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

--
Regards
Frank Kabel
Frankfurt, Germany

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

workbook?

 

[Paulw2k]

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

 

[Tom Ogilvy]

Use the workbook_Open event

see Chip Pearson's page on events

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