How to run a macro automatically when i open my excel spreadsheet

J

Jean-Yves

Hi,

In the Project explorer, open the "Thisworkbook" module
In the Top left dropdown of the module code window, select "Workbook" iso
"Declaration".
The top right dropdown gives you all the events associated with this
workbook, and for wich
you can have a sub.

Choose the "Workbook_Open"
Et voila.

Regards,

Jean-Yves
 
F

Frank Kabel

Hi
in addition to use the Workbook_Open event you may rename your macro
Auto_Open()
 
Top