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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protect an excel spreasheet by script in LotusNotes 5
How to goto a spreadsheet quickly 1
How to merge to coloums 1
Remove colour change 4
Finding Duplicate numbers 2
Macro question 7
New using macros 3
problem with unknown links 2

Back
Top