| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Annotating Line Series | Charts and Charting in Excel | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| annotating charts | Charts and Charting in Excel | |||
Hybrid Mode
