Consulting

Results 1 to 3 of 3

Thread: Can't Find a Link to Personal.xls

  1. #1

    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?

  2. #2
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    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.

  3. #3
    Thanx, FF.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •