Adding buttons with Macros assinged to new computer

[Guest]

I just started a new job and copied my toolbar and personal macro workbook
from my computer at the old job. I am using excel 2003. I copied the file
Excel 11 to a few places on my new computer so this may be part of my
problem. Anyway, when I open excel, I can see the buttons, but when I press
them, it says it can not find the macro. I went to the tools\macros menu and
assigned the macros to the applicable buttons. When I use the buttons in
that particular sesson of excel, they work. My problem arises when I close
excel and re open it. When I do that, my buttons do not work anymore. I
have to go back and reassign the macros to the buttons. Can anyone help?

 

[Dave Peterson]

Your life will become much simpler if you include code to create the toolbar
when the workbook is opened and include code to destroy the toolbar when the
workbook is closed.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

 

[Gord Dibben]

Changes to menus and toolbars are stored in your excel11.xlb file.

You could have more than one of these.............especially if you copied your
old one from previous computer to "a few places".

The default storage folder is

C:\Documents and Settings\username\Application Data\Microsoft\Excel

Do a search on your computer to find all instances of excel11.xlb

Note where they are then open Excel and make a change to a toolbar or menu.

Close Excel and see which excel11.xlb file has been changed.


Gord Dibben MS Excel MVP