Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
toolbar buttons to allocate VBA macro | Excel Discussion (Misc queries) | |||
Customized Toolbar Macro Buttons | Setting up and Configuration of Excel | |||
Excel Toolbar Macro Buttons | Setting up and Configuration of Excel | |||
Missing Macro Buttons on Toolbar | Excel Discussion (Misc queries) | |||
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! | Excel Programming |