you need to put your macro in a worksheet module or a workbook module
for the workbook module right click on the xl symbol at the top left of
the sreen and select view code and drop the box to select workbook, then
in the right box select the event you want for the macro to start, such
as workbook open will start your macro when you open your workbook,
there is lots of info on workbook and worksheet events
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.
