Macro Running at Spreadsheet Start

[MWhitehead]

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

 

[mangesh_yadav]

use the following sub in one of your modules

Sub Autpen()

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

end su

 

[Harald Staff]

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]

Thanks a million!

- Mik