Actuariojf
New Member
- Joined
- Aug 29, 2002
- Messages
- 15
I usually develop large excel workbooks that have just one output sheet which is linked with all other sheets in the workbook. However, when I have to deliver this output to other people I copy the output page to a new book, but all the links remain there as "=Cath ... ", so now I have to locate manually all the linked cells and do a copy-paste special as value, after that I change each one of the old linked cell to BOLD and colored them to BLUE.
My question, Can somebody do a macro that can locate automatically anywhere all the linked cells in an entire sheet, highlight these cells as blue bold and make the cell a hard values, so there will not be more links and all old linked cells will be easily identifiable in the sheet?
Thanks
Actuariojf
My question, Can somebody do a macro that can locate automatically anywhere all the linked cells in an entire sheet, highlight these cells as blue bold and make the cell a hard values, so there will not be more links and all old linked cells will be easily identifiable in the sheet?
Thanks
Actuariojf