Run Maco when workbook is first opened?

  • Thread starter Thread starter Brw
  • Start date Start date
B

Brw

My goal: I would like to run a macro I have set up to
automaticly run when the excel file is first opened each
time.

Is that possible? If so how? I don't know any coding so
hopefully it's simple or do you know any good instructions
on this?

thanks in advance@
Brw
 
Brw,

The easy way (there are others).

If you already have a macro created, rename it to Auto_Open.

Example:
Sub Macro1()
to
Sub Auto_Open()

John
 
Put your code in the Workbook_Open event un the ThisWorkbook code module,

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top