MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Using AUTO_OPEN MACRO on multiple sheets

Posted by Don Grubb on December 07, 2000 10:22 AM

How do I make the AUTO_OPEN Macro to work on multiple sheets in a workbook when
opening a workbook?

Posted by Celia on December 07, 2000 3:30 PM

This might not be what you meant, but the only difference between an AUTO_OPEN macro and a normal macro is the way in which they are triggered to run. So just use the same code in the AUTO_MACRO as you would use in a normal macro.