If you don't want to use workbook protection, then I don't think you can stop it
or catch it.

But you could use some other event to (Workbook_SheetSelectionChange???) to look
for it. If it's gone, give that user a severe chastising.

Or ...maybe... keep a hidden copy of the worksheet and just recreate that just
deleted worksheet. (This may not help--if you have formulas in other sheets
that refer to that worksheet, it'll be too late.)



JR_06062005 wrote:

Is there a way to prevent a userfrom deleting a single spreadsheet? I don't
want to lock down the whole workbook, but I would like to protect one
worksheet in the workbook. I was looking for something like:

Sub Worksheet_BeforeDelete (lgDelete as Boolean)

But of course, no such option exist. Any help will be greatly appreciated.

--

Dave Peterson