Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
maybe by cell coloring with embedded comment
hi to all,
"Maybe i can run a smart macro that can insert a comment in a cell if it is dependent to another WORKBOOK while BOTH WORKBOOKS ARE STILL ACTIVE.." to embed just the filename of the dependent workbook in a cell via comment or by coloring the cell (e.g. gold) can alarm me that such cell must never be deleted, unless the dependent workbook is open... i do not know how to make this possible in my excel2003SP2 i have 2 files. myfile1 contain cells that are used or referred by myfile2... when both files are open and i click Trace dependent on a cell in myfile1...i can see that this cell is being referred by myfile2....then i save and close both files.... when i open again only myfile1....and i click Trace dependent on the same cell...a pop up says that " ! The Trace Dependents COMMAND found NO formulas that REFER to the active cell." - an "OK" button appears as well.... for sure someone from this forum or some link can help me with this.. please help or recommend or whatever kinda smart suggestion... regards again -- ***** birds of the same feather flock together.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I restore cell gridlines lost after coloring a cell? | Excel Discussion (Misc queries) | |||
Cell Coloring | Excel Discussion (Misc queries) | |||
Cell coloring | Excel Discussion (Misc queries) | |||
Cell Coloring | Excel Worksheet Functions | |||
Coloring Cell Font based on Cell Contents | Excel Programming |