Protect the workbook.


Gord Dibben MS Excel MVP

On Sun, 6 Sep 2009 10:39:01 -0700, Bonsai Bill
wrote:

I have several sheets, some are hidden, that macros must have to run.
However, they are not static. The user pastes data into one of the unhidden
sheets and hidden sheets process the data. Ideally I would like to have a
sheet event that would flag and prevent the deletion of any of these sheets.
Can someone please offer a method that allows complete editing of a sheet but
prevents its deletion?

I am using Office 2007 with XP or Vista machines. Vista is slow!

Thanks for your help. The input to this forum is invaluable!