Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preventing users from changing macros | Excel Discussion (Misc queries) | |||
Preventing other users from opening hidden worksheets | Excel Discussion (Misc queries) | |||
Preventing users from unsharing a workbook | Excel Discussion (Misc queries) | |||
Preventing users from saving a spreadsheet | Excel Discussion (Misc queries) | |||
Help - Automating a file.. Adding Users , Deleting users, Changing | Excel Worksheet Functions |