Automatically run a macro
 

What do I name a macro to make it automatically run when the Excel file is
first opened? Thanks !

Either call it Auto_Open, 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)


"SheriTingle" wrote in message
...
What do I name a macro to make it automatically run when the Excel file
is
first opened? Thanks !

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
--
Sincerely, Michael Colvin


"SheriTingle" wrote:

What do I name a macro to make it automatically run when the Excel file is
first opened? Thanks !