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?
 

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