Show value, not formula in formula bar

[Derochema]

We have a client that does not want to see the formula in
the formula bar. I decided to protect the excel report and
hide all formulas, but that is not good enough. They still
want to be able to see the value in the formula bar.
Anyone have any idea how this can be done?

 

[Max]

How about selecting the entire sheet and convert all formulas to values ?
If this is palatable, .. :

Press Ctrl+A to select entire sheet, then
Right-click > Copy
Right-click > Paste special > Values > OK

 

[Derochema]

No it would'nt work because this is a report created
daily. No one would be able to go in do that for each
report. What happens is some value come into the excel
from sql server, the report then has some formulas that
grabs totals etc...

Thanks for your reply.
Mike

 

[Max]

Perhaps hide the formula bar ? (Remove the "root" of discontent <g>)
via: Tools > Options > View tab > Uncheck "Formula bar" > OK

And maybe disable "Edit directly in cell" as well
via: Tools > Options > Edit tab > Uncheck"Edit directly in cell" > OK

Beyond these "lateral" suggestions, think it's not possible otherwise ..
as a cell can only contain either a value or a formula at any instant, not
both

 

[AlfD]

Hi!

Certainly you will have to hide the Formula Bar.
This then conflicts with showing something in the formula bar.

So: if you want to see something, you will have to show it somewher
else.

The following sub will echo the value of any clicked cell in A1.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A1").Value = ActiveCell.Value
End Sub

Would that suit your client?

Al