If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|