Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Toolbar cannot find macro (Excle 2003)

    I mailed my work Personal.xls and my work Excel11.xlb files home and copied them to where my XLStart file was located in my XP PRO directory. THe toolbar comes up fine but when I click an icon for the macro, I get a message giving the exact pathway I stored the Personal file to, including the exact name of the macro, but saying that the macro cannot be found. I have restarted Excel to no avial. So I added a new Macro toolbar button, linked it to a macro in Personal.xls and saved eveything. I reopend a file. The newly created toolbar button appeared for 1 second then disappeared completely! I did that twice. Any ideas as to what's going on?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Toolbar cannot find macro (Excle 2003)

    Personal.xls should be in Cocuments and Settings<username>Application DataMicrosoftExcelXLStart, but Excel11.xlb should be in Cocuments and Settings<username>Application DataMicrosoftExcel, not in ...XLStart.

Posting Permissions

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