Execute macro at opening file

[clippan]

I have learned to do simple macros in Excel and how to combine them
with CTRL+a and so. Now I would like to have a worksheet with some
areas being erased at the opening of the file to make a clean start.
I can do it with a macro like Ctrl+a but how shall I do to have the
macro automatically run at the opening of the file, like the autostart
in Windows?

 

[Ron de Bruin]

Hi

You can use the open/activate event of the workbook
See this page for more information
http://www.cpearson.com/excel/events.htm