Run a macro when opening a spreadsheet
 

How or where do I invoke a macro when I open a spreadsheet.

name it autoexec

Hi Duncan,

In the workbook's ThisWorkbook Module, insert a

Sub workbook_open()
'Your code
End Sub

macro. To access this module, right-click the Excel icon to the left of
"File" on th menu bar, select "View Code".

Alternatively, in a general module, insert a

Sub Auto_Open
'Your Code
End Sub

macro.

If you are unfamiliar with macros, see David McRitchie's Getting Started
with Macros and User Defined Functions notes at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm


---
Regards,
Norman



"Duncan Help" wrote in message
...
How or where do I invoke a macro when I open a spreadsheet.

"Norman Jones" wrote in message
...
To access this module, right-click the Excel icon to the left of
"File" on th menu bar, select "View Code".

This is true if you have your spreadsheet maximized, but if you don't as in
my case, the icon is at the top-left of the spreadsheet, not by the File
menu.

Hi Bob,

Thank you - I will expand the instructions in future!


---
Regards,
Norman



"Bob Phillips" wrote in message
...

"Norman Jones" wrote in message
...
To access this module, right-click the Excel icon to the left of
"File" on th menu bar, select "View Code".

This is true if you have your spreadsheet maximized, but if you don't as
in
my case, the icon is at the top-left of the spreadsheet, not by the File
menu.

Been there Norman. I think it was Gord Dibben that corrected me :-)

Bob


"Norman Jones" wrote in message
...
Hi Bob,

Thank you - I will expand the instructions in future!


---
Regards,
Norman



"Bob Phillips" wrote in message
...

"Norman Jones" wrote in message
...
To access this module, right-click the Excel icon to the left of
"File" on th menu bar, select "View Code".

This is true if you have your spreadsheet maximized, but if you don't as
in
my case, the icon is at the top-left of the spreadsheet, not by the File
menu.