What Should I do in this situation
 

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

What Should I do in this situation
 

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

What Should I do in this situation
 

On Aug 19, 9:34*am, Luke M wrote:
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- Hide quoted text -

- 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.

What Should I do in this situation
 

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



"Dave" wrote in message
...
On Aug 19, 9:34 am, Luke M wrote:
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- Hide quoted text -

- 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.

What Should I do in this situation
 

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

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Dave" wrote in message
...
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

What Should I do in this situation
 

On Aug 19, 10:29*am, "Niek Otten" wrote:
Use an "overruler cell". Change your reference to a formula:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dave" wrote in message

...



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- Hide quoted text -

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