maybe by cell coloring with embedded comment

D

driller

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auditing tool question 0
maybe i can get reply here... 0
macro to insert a comment 0
Pasting a cell into bookmarked table from excel vba 1
Code to add comments to selected cells within a selected range 30
Is there a way to force Excel 2007 to recalculate just one cell? 7
Embed the same Excel multiple times 0
Trace dependents - can it auto-update / is there a keyboard shortc 0

Top