Deleting a Sheet
If you Protect the workbook sheet delete will be disabled
ToolsProtectionProtect Workbook
Abdul Salam
-----Original Message-----
Hi,
I am currently using the Sheet_Deactivate event to check
if a user
try's to delete a sheet. Is there anyway to cancel the
actual sheet
deletion after the user has selected Delete on the Excel
message box
that is displayed when deleting any sheet? Basically
what I am trying
to do is stop users deleting a sheet if it has
particular information
on it?
Any ideas?
Thanks in advance..
Rick
.
|