Prevent deleting of cells

I

IHeartSpreadsheets

Hello,

I have a spreadsheet that is used by many people to enter information. I
want to stop them from deleting individual cells or sections of cells but do
not want to protect the cells as I still need them to be able to enter
information.

Any ideas?

Thank you.
 
J

John Bundy

If you protect the sheet, and check every box other than delete column,
delete row, then you can select the range, or all ranges (unprotect book
first) and go to Tools->Protection->Allow Users to Edit Ranges->New, make
sure the ranges are in the box, and click Protect Sheet. Now they can edit
cells but they cannot delete rows or columns.
 

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

Protecting cell contents 3
Code for multiple select of cells 16
protect columns (prevent addition or deletion) 3
VBA code to protect cells Outside a given range 2
Array with many cells from a row but not in order or together 11
Strip out certain rows that have merged cells 2
Formatting unlocked cells and stop users from pasting 4
visual basic Loop by rows in Excel 3

Top