Editing an unprotected Cell in a Protected Worksheet in Excel 2003

J

Jem Blok

Hi

I have a worksheet that I wish to protect so that certain cells with
formulas cannot be changed. I have formatted the cells I wish to protect so
that they are locked when the sheet is protected.

However, if I then wish to edit one of the unprotected cells, rather than
allow me to simply change what I had previously entered, as soon as I
double-click on the cell to edit the previously entered data, the cell
contents disappear.

Very annoying if the entry is a long text string with a simple spelling
error.

Anyone know how I can change this so that I can edit the unprotected cells
as normal?

Thanks
Jem
 

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

Excel 2003 - how to check is all worksheet is protected 1
How can I merge unprotected cells in a protected worksheet? 1
Copying in sheet with protection with the use of a macro 5
Move to next unprotected cell 6
Worksheet protected by Activesync 0
Merging from an Excel file with graphics 1
Returned position address on protected sheet 7
I can still select & manipulate locked & protected cells in '07 1

Top