How do i trigger a macro when a spreasheet opens?

  • Thread starter Thread starter Neil
  • Start date Start date
Hi Neil

you put the code in the "ThisWorkbook" module (you'll see it in the VBE
window under your file name - generally on the left hand side of the
screen - if you can't see anything there choose view / project explorer from
the menu)

double click on the ThisWorkbook module and then on the right from the left
hand side drop down box choose Workbook and you'll get a new sub for
Workbook_Open

put the code in here.

Cheers
JulieD
 
Thanks Julie

That works fine

Neil

JulieD said:
Hi Neil

you put the code in the "ThisWorkbook" module (you'll see it in the VBE
window under your file name - generally on the left hand side of the
screen - if you can't see anything there choose view / project explorer from
the menu)

double click on the ThisWorkbook module and then on the right from the left
hand side drop down box choose Workbook and you'll get a new sub for
Workbook_Open

put the code in here.

Cheers
JulieD
Click to expand...
 
Back
Top