Avatar of BirdWatchers
BirdWatchers
 asked on

Active sheet has linked cells

If activeworkbook.linkedsources determines if the workbook has links, what about tab specific?  Activesheet.linksources doesn't work.
Microsoft ExcelVBA

Avatar of undefined
Last Comment
Martin Liss

8/22/2022 - Mon
Saurabh Singh Teotia

You can use the following add-in..

http://www.manville.org.uk/software/findlink.htm

This will tell you all your links in your excel workbook and which range or which sheet they exists..

Saurabh...
BirdWatchers

ASKER
with hundreds of users I am not allowed to use add-ins. Must be in VBA.
Saurabh Singh Teotia

So what i understand you want to list all the links which is their on the workbook??

Saurabh..
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER CERTIFIED SOLUTION
BirdWatchers

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Saurabh Singh Teotia

Do you need help on the code?? or what you are looking for by posting the code here?
Martin Liss

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.