Creating read only cells in Excel 2000

  • Thread starter Thread starter NEERAJ
  • Start date Start date
N

NEERAJ

I use Excel 2000, and create files and send to various
people for inputs. I want that the data which I am sending
should be readonly, i.e. users should not be able to
modify the contents of the cells, although they could
delete the rows/columns. How can I do it ?
 
You can try protecting the cells in question. Use a
password to stop others from unprotecting.
 
The bad news is if you lock your cells
Ctrl-A to select all
Format|Cells|Protection Tab|check locked

Then protect the worksheet
tools|protection|protect sheet

the users won't be able to delete rows or columns.

Excel2002 has finer control of this and would allow it. But not previous
versions.

If you want the users to delete rows/columns, then you could provide a macro
that unprotects the sheet, deletes, and reprotects. (You could protect the
sheet in code and not need to unprotect it, too.)
 
And be aware that the protection in excel (both worksheet and workbook) is very
weak. There is code posted here almost every day that will unprotect the
workbook/worksheet.
 
Back
Top