S
SheriTingle
What do I name a macro to make it automatically run when the Excel file is
first opened? Thanks !
first opened? Thanks !
B
Bob Phillips
Either call it Aut
pen, or else put the code inside the Workbook_Open
event in the Thisworkbook code module.
--
HTH
RP
(remove nothere from the email address if mailing direct)
pen, or else put the code inside the Workbook_Openevent in the Thisworkbook code module.
--
HTH
RP
(remove nothere from the email address if mailing direct)
M
Michael
Hi SheriTingle. You can name the macro anything you want, you just have to
put it in the correct place. See this site for "Worksheet change events."
http://www.mvps.org/dmcritchie/excel/event.htm
put it in the correct place. See this site for "Worksheet change events."
http://www.mvps.org/dmcritchie/excel/event.htm