pebbles555
New Member
Is there a way to allow users to make changes to the worksheet but disable adding/deleting rows or columns functionality in the spreadsheet?
Disable adding/deleting rows or column
- Thread starter pebbles555
- Start date
bobhc
Excel Ninja
Good day pebbles555
Try this
if you have version 2002 and above you can do this via tools / protection /
protect sheet, in 2010 via the review tab
first unlock all cells (select all cells / format / cells - protection -
untick locked)
then choose tools / protection / protect sheet - tick everything except
inserting & deleting columns & rows
click OK
THIS IS NOT MY WORK THANK JUILED ON EXCEL FORUMS
Try this
if you have version 2002 and above you can do this via tools / protection /
protect sheet, in 2010 via the review tab
first unlock all cells (select all cells / format / cells - protection -
untick locked)
then choose tools / protection / protect sheet - tick everything except
inserting & deleting columns & rows
click OK
THIS IS NOT MY WORK THANK JUILED ON EXCEL FORUMS