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-Žex" 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-Žex
------------------------------------------------------------------------
T-Žex'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