If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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!! |
Thread Tools | |
Display Modes | |
|
|