Macro on Quick Access

K

Kerry

I have been successful dozens of times by adding macros to my Quick Access
Toolbar. This time, however, I'm having a problem. The macro I created
("convert") is a merging of two other macros ("convertinstructions" and
"convertbenchbook"). I deleted the previous icon from the toolbar and added
the new "convert" macro icon. When I clicked on it, a message box came up
with the words "Microsoft Visual Basic" at the top and just a red circle with
a white X in the middle, with two options to click "OK" and "Help". However,
when I open the Macro menu and Run it, it works perfectly. I have
reinstalled the previous icon as well as other icons and they all work, just
not "convert". I have deleted it from the Visual Basic and re-created it,
and I have also exited out of all Office apps to try and reset anything that
may be making this happen. Can anyone help me to figure out why this
particular one just won't work?
 
K

Kerry

It really doesn't have anything to do with the code, because it does run when
I open the Macro menu and run it from there. Also, all the other macros that
I put on the Quick Access toolbar perform fine. It's just that there's
something wrong with this particular one. Any ideas?
 
Joined
Apr 25, 2012
Messages
1
Reaction score
0
I have just encountered the same problem. After spending ages googling for a solution, I stumbled across it myself. I don't know if it's the same cause in every instance, but in my case it was simply the name of the macro. Mine was "Envelope", obviously being recognised by Word as something other than a user macro. Changing the name to "PrintEnvelope" (or anything other than "Envelope") resolved the issue. Other people that I found had been reporting this problem had macros called "Email" and "convert". It's quite possible that names like this would cause the same issue.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top