MrExcel.com - Your One Stop for Excel Tips & Solutions

Suppress workbook_open macro

Posted by Tommy Christensen on April 09, 2001 12:41 PM

I have placed a macro i this_workbook named workbook_open and the workbook then runs this macro automaticly when it open.
How can I suppress this macro??

regards
Tommy

Posted by steve on April 09, 2001 9:19 PM


tommy
What do you mean suppress, To not have it run or to have a chose to have it run or not run?

steve

Posted by Tommy Christensen on April 09, 2001 9:49 PM

I would like NOT to run!
Regards
Tommy

Posted by Dave Hawley on April 09, 2001 11:35 PM

Hi Tommy

Open the Workbook from within Excel and hold down your shift key.


Dave

OzGrid Business Applications

Posted by Tommy Christense on April 10, 2001 7:30 AM

Thanks Dave