ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Preventing users from deleting worksheets (https://www.excelbanter.com/excel-programming/282481-preventing-users-deleting-worksheets.html)

Alice[_3_]

Preventing users from deleting worksheets
 
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?

Trevor Shuttleworth

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?




Tom Ogilvy

Preventing users from deleting worksheets
 
Protect the structure of the workbook. (under tools=Protection)

--
Regards,
Tom Ogilvy

"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?





All times are GMT +1. The time now is 02:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com