Identifying formula links between Worksheets within a Workbook

[xcellrodeo]

Hi All,
I would appreciate some help with the following problem:
I have a workbook (using Excel2013) with ca. 20 named worksheets of which I would like to delete approx. 10.
Having earmarked these 10 sheets for deletion, I just want to check if the Worksheets which will not be deleted, are linked in any way to those 10 that I wish to delete.
Is there a way of doing this maybe even through a VBA coding which will return the Sheet name and cell reference and where it is linked to?

Many thanks

 

[Peter_SSs]

See if this thread is any help.

 

[xcellrodeo]

Hi Peter_SSs
Thanks so much for the link. This appears to do the job.
Somebody must have spent a long time writing that code

 

[Peter_SSs]

Hi Peter_SSs
Thanks so much for the link. This appears to do the job.
Somebody must have spent a long time writing that code

Cheers. The good news is you only have to write it once & record it somewhere, & remember where you stored it! )

 

[xcellrodeo]

Peter_SSs, Indeed well done!