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