macro toolbar button problem

N

NewToVB

I've created a short macro and I've added a button to the excel toolbar (I'm
using excel 2007). The macro security setting is set to enable all
macros...but when I open up another excel sheet other than the one that the
macro was created in and try to run the macro.. I get the following error:

"Cannot run the macro "XXX". The macro may not be available in this
workbook or all macros may be disabled."

Any ideas on how to solve this problem? I'm sure it's probably easy but I
can't seem to figure it out. Thanks in advance!!
 

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

Similar Threads

How to call Excel add-in macro from a button… 1
Macro button for all files 1
Excel button problem 2
Toolbar macro re-named 4
Excel 2007 Macro Security 2
toolbar macro on template 11
assign macro - toolbar 2
How do I refer to a custom toolbar button? 3

Top