D
Duncan Help
How or where do I invoke a macro when I open a spreadsheet.
D
dlw
name it autoexec
N
Norman Jones
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 Aut
pen
'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
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 Aut
pen'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
B
Bob Phillips
Norman Jones said:
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.
N
Norman Jones
Hi Bob,
Thank you - I will expand the instructions in future!
Thank you - I will expand the instructions in future!
B
Bob Phillips
Been there Norman. I think it was Gord Dibben that corrected me
Bob
Bob