With the sheet unlocked, select the cell the user may need to edit. Format
cell, protection, uncheck the "locked" option.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Dave" wrote:

hi,

I am on Excel 2003, I have spreadsheet with a range of cell that
contain cell refrences to other cell in the same spreadsheet. Once I
protect this sheet then these cell are locked out for editing by the
user. Here is the problem sometimes the user has to be able to
overwrite this value and enter a new one in its place. What can I do
in this situation.

thanks in advance

Dave