Link to home
Start Free TrialLog in
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.
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

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...
Avatar of BirdWatchers
BirdWatchers

ASKER

with hundreds of users I am not allowed to use add-ins. Must be in VBA.
So what i understand you want to list all the links which is their on the workbook??

Saurabh..
ASKER CERTIFIED SOLUTION
Avatar of BirdWatchers
BirdWatchers

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Do you need help on the code?? or what you are looking for by posting the code here?
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.