"Protecting" a sheet

[Guest]

After appropriately assigned locked or unlocked fomrating to the cells in my
worksheet, I chose to "protect sheet". This brings up a bos with options you
can choose to let users perform (i.e. insert rows, delete rows, etc.). After
applying the protection, the options I chose to let users perform are not
available. What am I doing wrong?

 

[Peo Sjoblom]

Are they using the same version of Excel as you?


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Guest]

Yes. We are both using Excel 2003. I have built invoicing templates/forms
and only want those cells that need data entered to be accessible. However,
the ability to delete unnecessary rows or add additional ones in the detail
area of the invoice is required. After applying protection, those options
are "greyed out" and not accessible despite the fact that I chose both option
for users. Don't know what else to do.

 

[Gord Dibben]

The options found under Tools>Protection>Protect Sheet are somewhat misleading.

You can delete rows and delete columns only if all(that is "all") the cells in
those rows and columns have been set to "unlocked" prior to protecting the
sheet.

Same for inserting rows and doing sorts on unlocked sections of the sheet.


Gord Dibben MS Excel MVP