Preventing insertion and deletion of rows/columns

karraj · May 22nd, 2002, 08:40 AM

I do not want users to insert or delete rows/columns in my worksheet. How can I ensure that. I do not want to protect the sheet as I want to update the contents of the cells.
Thanka,
Karraj

sann0638 · May 22nd, 2002, 08:59 AM

a crude way would be to put a value on which an important value depends in cell IV65536 (the bottom right cell). If any rows or columns were inserted, a warning would come up and if this was ignored the formulae could go wrong. It depends whether your users are aware that you do not want this to be done - if they are happy not do, but may not know, then a message should work, but if they are malevolent then they are likely to get round protection.

karraj · May 23rd, 2002, 08:20 AM

Thanks Mike, that workaround helps.

Is there a simpler way to just disable insertion and deletion of rows for a particular spreadsheet.

Karraj.

lenze · May 23rd, 2002, 08:28 AM

You can still use Sheet protection and edit cells. Simply unlock the cells you want to be able to edit under Format>Protection before you protect the sheet.

May 22nd, 2002, 08:59 AM	#2
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	a crude way would be to put a value on which an important value depends in cell IV65536 (the bottom right cell). If any rows or columns were inserted, a warning would come up and if this was ignored the formulae could go wrong. It depends whether your users are aware that you do not want this to be done - if they are happy not do, but may not know, then a message should work, but if they are malevolent then they are likely to get round protection. __________________ Regards, Mike.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 08:40 AM	#1
karraj Board Regular Join Date: Mar 2002 Posts: 76	I do not want users to insert or delete rows/columns in my worksheet. How can I ensure that. I do not want to protect the sheet as I want to update the contents of the cells. Thanka, Karraj

May 23rd, 2002, 08:20 AM	#3
karraj Board Regular Join Date: Mar 2002 Posts: 76	Thanks Mike, that workaround helps. Is there a simpler way to just disable insertion and deletion of rows for a particular spreadsheet. Karraj.

May 23rd, 2002, 08:28 AM	#4
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	You can still use Sheet protection and edit cells. Simply unlock the cells you want to be able to edit under Format>Protection before you protect the sheet.