toolbar macro buttons
 

Hello all,

I have created a series of macros, saved them in my personal.xls macro
sheet. Created the toolbar buttons, assigned the macros to the buttons.
Tested them saved the whole ball of wax, and exited excel. No problem....
Big problem. When I go back into excel and try to use the same buttons what
happens is I get the list of macros available on all open workbooks for me to
choose the macros I want. The list does contain all macros recorded in my
personal.xls book so it is opening with excel. Does anyone have any idea why
these buttons / macros are not working?

Version is excel 2002 SP3

I am sorry I also posted this under general questions, did not intentionally
post twice.

toolbar macro buttons
 

It may be referencing the personal.xls workbook, not the activeworkbook.

"mendozalaura" wrote:

Hello all,

I have created a series of macros, saved them in my personal.xls macro
sheet. Created the toolbar buttons, assigned the macros to the buttons.
Tested them saved the whole ball of wax, and exited excel. No problem....
Big problem. When I go back into excel and try to use the same buttons what
happens is I get the list of macros available on all open workbooks for me to
choose the macros I want. The list does contain all macros recorded in my
personal.xls book so it is opening with excel. Does anyone have any idea why
these buttons / macros are not working?

Version is excel 2002 SP3

I am sorry I also posted this under general questions, did not intentionally
post twice.