"Protecting" a sheet
 

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?

"Protecting" a sheet
 

Are they using the same version of Excel as you?


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Iowanorth" wrote in message
...
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?

"Protecting" a sheet
 

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.

"Peo Sjoblom" wrote:

Are they using the same version of Excel as you?


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Iowanorth" wrote in message
...
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?

"Protecting" a sheet
 

The options found under ToolsProtectionProtect 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

On Mon, 17 Apr 2006 11:29:02 -0700, Iowanorth
wrote:

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.

"Peo Sjoblom" wrote:

Are they using the same version of Excel as you?


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Iowanorth" wrote in message
...
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?