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!!