Try this Sub Auto_Open() Record macro as normal. Auto_Open will run everytime.
J J.E. McGimpsey Oct 28, 2003 #2 not quite true - Auto macros do not automatically run if the workbook is opened from code. Instead use the Worksheet_Open() event macro.
not quite true - Auto macros do not automatically run if the workbook is opened from code. Instead use the Worksheet_Open() event macro.
pen()pen will run everytime.pen()pen will run everytime.