View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default Preventing users from deleting worksheets

Alice

protect the workbook in the same way that you protect the sheets.

Tools | Protection | Protect Workbook...

Regards

Trevor


"Alice" wrote in message
...
I already put a protection onto all worksheets within my
workbook, however it does not prevent the user from
manually deleting the protected worksheets. Is there a
way to prevent users from deleting worksheets from a
workbook?