-
Can't Find a Link to Personal.xls
I just completed rebuilding (from scratch) a workbook that had become corrupted some how. When I checked the links, it shows I have one or more links to Personal.xls, whereas the original workbook didn't show the link. I searched the Defined Names list and did a "Find" search on the whole workbook looking for Personal in formulas, and I can't find it. Then I went through all the AutoShapes that have macros assigned to them, and none show Personal. Where else should I look?
Is there an easy way to check AutoShapes en masse to see what macros are assigned to them?
-
Hey Sid, check out this page at Stephen Bullen's site..
http://www.oaltd.co.uk/MVP/Default.htm
.. the first link should be under Bill Manville's area, it's the FindLink.xla add-in. It will hunt those links down for you.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules