Disable Insert Row and Column

[tazzmacd]

I have a work sheet layout that we want to keep static accept for some cells that the users can update. Right now they could be allowed to remove rows or columns that do not pertain to the project but I do not want additional rows or columns being added.

Is there a way to disable the ability for a user to add in a row or column to a spreadsheet but allow them to delete rows and Columns?

On the flip side, if we disable the removal how can I do that also. Thanks

Cheers!!

Pat

 

[wigi]

Hello Pat

Did you have a look at the options you have, when you protect a worksheet? Among others, inserting and/or deleting rows and/or columns.

FYI, providing a password is optional when you protect a sheet.

 

[tazzmacd]

well don't I feel like such a NOOB!!!!

Forgot all about that feature.

Thanks

Pat