Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,355
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
toolbar buttons to allocate VBA macro Roland Excel Discussion (Misc queries) 2 February 21st 09 04:57 PM
Customized Toolbar Macro Buttons MSThinksItKnowsBetter Setting up and Configuration of Excel 8 June 1st 08 09:28 AM
Excel Toolbar Macro Buttons MSThinksItKnowsBetter Setting up and Configuration of Excel 0 May 17th 08 02:24 AM
Missing Macro Buttons on Toolbar Parker Excel Discussion (Misc queries) 3 March 24th 06 03:01 PM
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! Kevin Waite Excel Programming 2 March 3rd 04 03:31 PM


All times are GMT +1. The time now is 10:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"