Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
protecting sheet
Morning all,
I'm trying to understand the purpose of the "Allow all users of this worksheet to:" in the protect sheet menu. It implies that a worksheet can be protected in a granular fashion. For example I could allow the user to insert columns, add data, format rows, but not delete columns or rows. When I try selecting these options and then save the sheet, i'm always prompted to unprotect before any data can be entered. I'm trying to understand the purpose of the "Allow all users of this worksheet to:" check boxes. If it's necessary to unprotect before data can be added, it's unclear what function these check boxes assume. Any help is appreciated. Thanks Art |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
protecting sheet
Check your other post.
Art Cummings wrote: Morning all, I'm trying to understand the purpose of the "Allow all users of this worksheet to:" in the protect sheet menu. It implies that a worksheet can be protected in a granular fashion. For example I could allow the user to insert columns, add data, format rows, but not delete columns or rows. When I try selecting these options and then save the sheet, i'm always prompted to unprotect before any data can be entered. I'm trying to understand the purpose of the "Allow all users of this worksheet to:" check boxes. If it's necessary to unprotect before data can be added, it's unclear what function these check boxes assume. Any help is appreciated. Thanks Art -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting sheet | Excel Discussion (Misc queries) | |||
protecting a sheet | Excel Discussion (Misc queries) | |||
Can't use tab after protecting sheet. | Excel Worksheet Functions | |||
Protecting Sheet | Excel Worksheet Functions | |||
Can't use tab after protecting sheet. | Excel Discussion (Misc queries) |