?
Solved

Personal.xls not working

Posted on 2014-03-18
17
Medium Priority
?
211 Views
Last Modified: 2014-03-19
Hi experts!

I created a toolbar two years ago for Excel and saved it and its macros to the OFFICE11\XLSTART directory. It's been working just fine until last week when I started getting the message MACRO NOT FOUND with the path OFFICE11\XLSTART showing. When I go to MACROS it sees my macros and I can run a macro from MACROS but they seem to be invisible to my toolbar. What happened??
0
Comment
Question by:Eddie_Aeffect
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 10
  • 7
17 Comments
 
LVL 31

Expert Comment

by:gowflow
ID: 39937377
can you post the workbook that contain the macro ?
gowflow
0
 

Author Comment

by:Eddie_Aeffect
ID: 39937389
Does it matter what macros are in the workbook? It is the path that seems to be the issue. Somehow that path is now disconnected from the toolbar.
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39937404
you mean on the tool bar you have a button you press it and nothing happens ?
gowlfow
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

Author Comment

by:Eddie_Aeffect
ID: 39937415
Yes. For two years now, when I clicked a button, the macro would work. Now no matter what button I choose it tells me it can't find the macro EVEN THOUGH I can see it when I go to TOOLS\MACROS.
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39937426
ok did you upgrade to a new version of excel ? what version you were using you said OFICE11 so presume it is Excel 2003 are you still at this version or now 2007/2010 .. ?
gowflow
0
 

Author Comment

by:Eddie_Aeffect
ID: 39937439
Yes, we are on Office 2003. Sometime this year we will probably upgrade though I hate the new toolbar! But no, I haven't upgraded the one I am working on for years. Excel just seems to have developed amnesia and can't remember the macros in the VBA module.
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39937448
pls post the workbook personal.xls and advise what is the full path of the location of this file on your drive.

gowlfow
0
 

Author Comment

by:Eddie_Aeffect
ID: 39937649
Here is the path on my computer:
C:\Program Files\Microsoft Office\OFFICE11\XLSTART\Personal.xls
Personal.xls
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39938027
ok fine for the location now what is the macro that sets your toolbar as I see by default no macro is set to run upon loading. So maybe for some reason it has been disactivated so I  need to know which one loads the toolbar menu if you know.
gowlfow
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39938041
I don't know if this would work but no harm to try. Put this file in your XLSTART folder and rename the other one as old.

Let me know if this fixes the issue.
gowflow
Personal.xls
0
 

Author Comment

by:Eddie_Aeffect
ID: 39938047
I originally created the toolbar by using CUSTOMIZE to add icons to my toolbar and attached macros to them. From that point on, the toolbar was there. But you can create it in Excel by running the CreateAeffectToolbar macro (though I didn't update it for one macro). Does that make sense?
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39938116
yes sure it got lost by an office update somehow. Did you try running now the new personal.xls  that I posted ?
gowflow
0
 

Author Comment

by:Eddie_Aeffect
ID: 39939765
I moved the old personal.xls to another folder and put in the new one. Unfortunately, it is the same. I can see the macros in TOOLS\MACRO and run them from there but when I try running any of them from the toolbar, I get THE MACRO CANNOT BE FOUND and the path where I stored the personal.xls. I finally decided to delete the toolbar and regenerate it to and that fixed the issue but now I want to understand what caused this? Is there a link to the toolbar that can be broken?

Have a great day!
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39939909
doe sit tell you file not found or nothing happens ?
gowlfow
0
 

Author Comment

by:Eddie_Aeffect
ID: 39939934
When I regenerate the toolbar it works just fine, no error messages. I just want to know how to "reconnect" the toolbar if this happens again.
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39940187
I will try here to see what happens.
will revert
gowflow
0
 
LVL 31

Accepted Solution

by:
gowflow earned 800 total points
ID: 39940334
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to add a user-defined command button to the Windows 7 Explorer toolbar.  In the previous article (http://www.experts-exchange.com/A_2172.html), we saw how to put the Delete button back there where it belongs.  "Delete" is …
If you have ever found yourself doing a repetitive action with the mouse and keyboard, and if you have even a little programming experience, there is a good chance that you can use a text editor to whip together a sort of macro to automate the proce…
Viewers will learn what comprises a theme in Excel 2013, as well as how to customize them.
Viewers will learn how to find and create templates in Excel 2013.

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question