Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |