protecting sheet


A

Art Cummings

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
 
Ad

Advertisements

D

Dave Peterson

Check your other post.

Art said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top