Annotating Cell/Value in Cell
Thanks!
"Gord Dibben" wrote:
Marie
You could select the cells with the +N notation and
FormatCellsProtection"Hidden".
Nothing would appear in the formula bar.
You would have to protect the worksheet in order for this to take effect.
May not be desirable for your situation and worksheet protection is easily
cracked.
Gord Dibben Excel MVP
On Tue, 14 Sep 2004 17:51:12 -0700, "Marie"
wrote:
That's a good idea and worked well with the sorting - didn't know that
function existed. But is there a more transparent way so that customers do
not see that notation in the formula bar or I can access via Macro/VBA?
Thanks
Marie
"Gord Dibben" wrote:
Marie
One way is to use the +N function.
=A2*A1+N("my wage+bonus-4 weekly loan repayments")
The text will show in the formula bar but not in the cell.
Gord Dibben Excel MVP
On Tue, 14 Sep 2004 14:13:04 -0700, "Marie"
wrote:
Hi
I am looking for a way to annotate a cell and have the annotation move with
the value in the cell if the rows are sorted.
This works well with comments, but I am looking for something more
transparent to the end user. Tried using named ranges for each cell, but
when I did the sort the name range did not move with the sort.
Thanks
Marie
|