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.. |
All times are GMT +1. The time now is 07:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com