View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Abdul Salam Abdul Salam is offline
external usenet poster
 
Posts: 15
Default 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
.