About
Pricing
Community
Teams
Start Free Trial
Log in
BirdWatchers
asked on
9/28/2015
Active sheet has linked cells
If activeworkbook.linkedsourc
es determines if the workbook has links, what about tab specific? Activesheet.linksources doesn't work.
Microsoft Excel
VBA
6
1
Last Comment
Martin Liss
8/22/2022 - Mon
Saurabh Singh Teotia
9/28/2015
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
9/28/2015
ASKER
with hundreds of users I am not allowed to use add-ins. Must be in VBA.
Saurabh Singh Teotia
9/28/2015
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
9/28/2015
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
9/28/2015
Do you need help on the code?? or what you are looking for by posting the code here?
Martin Liss
10/25/2015
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
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...