Prevent sheet deletion

[Guest]

Hi,

When you right-click on a sheet tab, there is an option to delete a sheet.
Even though this sheet is password protected for editing data, the delete
option still works and does not require a password. Therefore, is it
possibile to

i) When you click delete, to make excel ask you for the sheet password

OR

ii) To disable the delete sheet option (preferred option)

Help would be appreciated.

Thanks.

 

[Guest]

I don't believe there is any way to do this other than protecting the workbook.

Mike

 

[Guest]

try tools>protection>protect workbook>tick structure, with a password if you
want. Delete is then greyed out
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)