PDA

View Full Version : [SOLVED:] Can't Find a Link to Personal.xls



Cyberdude
08-05-2005, 10:37 AM
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? :bug:
Is there an easy way to check AutoShapes en masse to see what macros are assigned to them?

Zack Barresse
08-05-2005, 10:44 AM
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. ;)

Cyberdude
08-05-2005, 12:04 PM
Thanx, FF.