Macro Running at Spreadsheet Start
 

Hi, I wish to load a macro I have created when the spreadsheet firs
loads up. Is this possible? If so, how do I go about it?


I would like to thank you in advance for any help

--
Message posted from http://www.ExcelForum.com

Macro Running at Spreadsheet Start
 

use the following sub in one of your modules

Sub Auto_Open()

'Action to be done when the excel sheet starts
'enter your code here

end su

--
Message posted from http://www.ExcelForum.com

Macro Running at Spreadsheet Start
 

Hi

Rename the macro to
Sub Auto_open()
and it will. See also
http://www.cpearson.com/excel/events.htm
on events.

HTH. Best wishes Harald

"MWhitehead " skrev i melding
...
Hi, I wish to load a macro I have created when the spreadsheet first
loads up. Is this possible? If so, how do I go about it?


I would like to thank you in advance for any help.


---
Message posted from http://www.ExcelForum.com/

Macro Running at Spreadsheet Start
 

Thanks a million!

- Mik

--
Message posted from http://www.ExcelForum.com