ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   delete rows (https://www.excelbanter.com/excel-discussion-misc-queries/110039-delete-rows.html)

Jane

delete rows
 
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

Jim Rech

delete rows
 
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
"Jane" wrote in message
...
|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




All times are GMT +1. The time now is 10:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com