You can put code against the Workbook_Open procedure in the ThisWorkbook
module ...
open your workbook, press ALT & F11 to get to the VBE window
in the project explorer (view / project explorer) under your file (the name
will be bold & in brackets), you'll see all your sheets listed and then
something called ThisWorkbook
double click on it,
from the left hand side drop down box on the right hand side of the screen,
choose workbook and the
Private Sub Workbook_Open()
End Sub
will be created for you - put your code in here.
However, for the code to run - tools / macro / security needs to be set to
medium (or low, but don't recommend this) and if you're asked you need to
enable macros on opening the file.
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.
