Do you want the macro to run every time you open Excel or only when yo
open a spreadsheet?
Also depends on which version you are running.
You need to create a Worksheet_Open() macro. In the VBeditor copy th
macro from the module and paste in the proper place.
To run the macros each time excel is opened paste the macro on th
ThisWorkBook in the Personal.xls file (newer versions of excel). I
you have excel2000 or later and don't see personal.xls Go back t
Excel and try to Unhide it.
You can paste the macro in the ThisWorkBook of Book1.
If you only want to run the macro when opening the one workbook, past
it in it's ThisWorkBook.
HT
