And if you have multiple workbooks open and go from the Help sheet to a
different workbook, then the worksheet_deactivate event won't fire.

You may want to add Workbook_Activate and Workbook_Deactivate code, too.

(I like the workbook protection suggestion more and more <vbg>.)

Dave Peterson wrote:
>
> Norman's code will stop users from deleting the sheet if the user doesn't
> disable macros (and activates that sheet at least once) by stopping the menu
> commands.
>
> But I could still choose to move it to a new workbook--or even use code to
> delete that sheet.
>
> Just something to be aware of.
>
> On the other hand, workbook protection is easily broken, too.
>
> "T-容x" wrote:
> >
> > Hi!
> >
> > Is it possible to prevent a particular sheet from being deleted?
> >
> > I have a workbook that contains sheets (of course). One of the sheets
> > serves as a "Help" sheet. I don't want users to accidentally (or
> > intentionally)
> > delete just this sheet.
> >
> > --
> > T-容x
> > ------------------------------------------------------------------------
> > T-容x's Profile: http://www.excelforum.com/member.php...o&userid=26572
> > View this thread: http://www.excelforum.com/showthread...hreadid=401664
>
> --
>
> Dave Peterson

--

Dave Peterson