Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Hide formula, but display results
- Thread starter wtotten
- Start date
DaleWatson123321
Programmer
Bill,
How about placing the formula on a separate sheet - which you can hide.
Then use a simple formula to reference your "special" formula.
If for example, you assign a range name to the cell containing your special formula, then you can simply enter =xxx (Replace xxx with whatever name you decide to name the cell).
If you're not familiar with assigning range names, the method I use is:
1) Highlight the cell (or range of cells in some cases)
2) Hold down <Ctrl> and hit <F3>
3) Type the name, and hit <Enter>
Hope this helps.
Regards, ...Dale Watson dalwatson@gov.mb.ca
How about placing the formula on a separate sheet - which you can hide.
Then use a simple formula to reference your "special" formula.
If for example, you assign a range name to the cell containing your special formula, then you can simply enter =xxx (Replace xxx with whatever name you decide to name the cell).
If you're not familiar with assigning range names, the method I use is:
1) Highlight the cell (or range of cells in some cases)
2) Hold down <Ctrl> and hit <F3>
3) Type the name, and hit <Enter>
Hope this helps.
Regards, ...Dale Watson dalwatson@gov.mb.ca
If you go to format cells, Protection, then tick hidden.
this will hide the formula only when the cell is then protected,(tools, protection, protec worksheet) just make sure you unlock it so you can make changes if you need to
Regards, Phil
![[borg2]](/data/assets/smilies/borg2.gif "[borg2] [borg2]")
"If in doubt, hit it with an end user!
this will hide the formula only when the cell is then protected,(tools, protection, protec worksheet) just make sure you unlock it so you can make changes if you need to
Regards, Phil
"If in doubt, hit it with an end user!
Another option is to use names but not in the way Dale has suggested.
Once you have written your formula, you can go
Insert>Name>Define
and copy it into there instead of a range definition.
Give it a name (eg myForm) and then you can use that name in your cell so instead of seeing
=vlookup(A1,myRange,4,false)
you would see
=myForm
You could still see the formula but you can't see what it does
Rgds, Geoff
Never test the depth of water with both feet
Help us to help you by reading FAQ222-2244 before you ask a question
Once you have written your formula, you can go
Insert>Name>Define
and copy it into there instead of a range definition.
Give it a name (eg myForm) and then you can use that name in your cell so instead of seeing
=vlookup(A1,myRange,4,false)
you would see
=myForm
You could still see the formula but you can't see what it does
Rgds, Geoff
Never test the depth of water with both feet
Help us to help you by reading FAQ222-2244 before you ask a question
- Status
Similar threads
- Locked
- Question