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

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

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

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