• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to find out linked (reference) worksheet with activeworksheet

S

sdsurzh

Member
Hi,


I have workbook of 5 worksheets and all worksheets contains some formulas. I want to highlight if any other worksheet is linked with active sheet.


Example in Sheet1.A1 =B1+Sheet2!B1 in this case is it possible to highlight either by macro or conditional format or some other tricks.


Thanks,

Suresh Kumar S
 
Without Macros, there will be five steps involved (since you have five sheets),


CTRL + F in the find box


=sheet name * (Partial sheet name can be used, if you have sheet name common like sheet1, sheet 2, sheet3 then =sheet* can be used)


If you have many sheets, please comment, might be a Ninja would be able to help you through Macro...
 
Hi All..


Just for investigation purpose.. If you need to background detail.. you can visit below post.. origin of the question..


http://chandoo.org/forums/topic/trace-precedents


Regards,

Deb
 
You must log in or register to reply here.
Back
Top