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 |
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 |
All times are GMT +1. The time now is 06:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com