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
