delete rows

G

Guest

I have a protected worsheet that has certain cells unprotected so another can
enter data into a spreadsheet. When I go to protect the sheet and check
"insert rows" and "delete rows", it will only allow me to insert rows but not
delete, eventhough I checked the "delete rows" box. What am I doing
wrong?-Thansk
 
J

Jim Rech

I don't think you're doing anything wrong. The only way I can delete rows
is if the entire row is unlocked and I delete the entire row, not just some
cells in it.

--
Jim
|I have a protected worsheet that has certain cells unprotected so another
can
| enter data into a spreadsheet. When I go to protect the sheet and check
| "insert rows" and "delete rows", it will only allow me to insert rows but
not
| delete, eventhough I checked the "delete rows" box. What am I doing
| wrong?-Thansk
 

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

Similar Threads

Deleting Rows form Protected Sheet 1
Delete Rows in a protected worksheet 2
Protection permissions 3
Allow Insert Rows in a protected worksheet 2
Delete rows while sheet protected 3
ProtectSheet Options are un-checking after macro 9
Protect cells but allow for user input. 3
protect sheet macro problems 2

Top