MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Shared Workbook adds a new sheet Each time it is opened


Posted by Louis on February 03, 2001 9:29 PM

How can I stop the Shared workbook from adding a new Worksheet everytime it is opened. Your help appreciated. Thanks.


Posted by Dave Hawley on February 04, 2001 2:05 AM


Hi Louis

I suspect there is a Workbook_Open event or Auto_Open macro within the Workbook doing this.


To stop either or both from running hold down the Shift key while opening the file from within Excel.


OzGrid Business Applications

Posted by louis on February 04, 2001 5:00 AM

Absolultely correct!!! Just hide to find out what was happening in the Workbook Open event and all I can say is..Thank you. Dave is Awesome!!

Louis