What Should I do in this situation

[Dave]

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

 

[Luke M]

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

 

[Dave]

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!*








- Show quoted text -

Thanks, I know about what you are saying but this will overwrite my
cell refrence? I guess I was not very clear I want to be able to
reatina my cell refrence after the users is done entering the data .
this way the next time when they dont need to make the cahnge the
values will be carried over.

 

[RagDyeR]

You'll have to use an additional cell for the user's input to override the
existing link that you created.

For example, say your original link formula in D1 was:

=$B$1

Revise the formula to so that the user could enter a new value in say F1,
And that value will display in D1 instead of the value in B1.
If F1 is empty, the original link will display.

=IF(F1="",$B$1,F1)
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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!*








- Show quoted text -

Thanks, I know about what you are saying but this will overwrite my
cell refrence? I guess I was not very clear I want to be able to
reatina my cell refrence after the users is done entering the data .
this way the next time when they dont need to make the cahnge the
values will be carried over.

 

[Niek Otten]

Use an "overruler cell". Change your reference to a formula:

=IF(OverRulerCell="",OriginalReference,OverRulerCell)

 

[Dave]

Use an "overruler cell". Change your reference to a formula:

=IF(OverRulerCell="",OriginalReference,OverRulerCell)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel









- Show quoted text -

Thanks It works, you guys are the best? Can you recommend a good book
to learn all these special ways to do stuff!!