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

Art;

When you select the things that are allowed they should (normally) work
without unprotecting the sheet.

So, it might be that you get the message because your action(s) conflict
with somethings else (which is still restricted because of protection).
I have to be carefull because it's a little bit of a grey area, but I think
that this must solve the matter.

--
Regards;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Netherlands
--
E:
W: www.spreadsheetsolutions.nl
--

"Art Cummings" wrote in message
...
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

Check 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