Hi All,
linkback http://www.mrexcel.com/forum/excel-q...book-help.html
I want to disable/prevent user to delete sheet (both through Home > Cells > Delete Sheet, or Right click on sheet > Delete), but I can't use protect workbook for this one. so VBA code is the only way, I've search anywhere but it fails because the code for excel 2007.
block this menu
FORUM.JPG
block this right click menu too
Capture2.JPG
Please help,
thanks a lot
warm regards
Adrian
There is no really elegant way to do this. There is one suggestion (which I have not confirmed) on this page. This implements workbook-level protection but only temporarily, long enough to prevent the sheet from being deleted:
You can prevent a sheet from being deleted via the Worksheet_BeforeDelete Event as follows:
This will protect all sheets from being deleted. However, if you add some event code like the following on the ThisWorkbook module:
Please Login or Register to view this content.
The user will then be able to delete any other sheet as soon as they select it.Please Login or Register to view this content.
Hi StringJazzer,
thanks for the reply, but, well, seems there's no better option out there... will postpone this idea.
cheers
Adrian
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks