Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.misc
|
|||
|
|||
Protecting sheet
Hi Art,
Go to the excel help and enter protect sheet, it will give you and excellent explanation "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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting sheet
Thanks Eduardo,
I had read the on-line help and many google post but did not find an explanation. Art "Eduardo" wrote in message ... Hi Art, Go to the excel help and enter protect sheet, it will give you and excellent explanation "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting sheet
You have an active thread at one of your other posts.
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 a sheet | Excel Discussion (Misc queries) | |||
Protecting a sheet and still allow some features | 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) |