Adding buttons with Macros assinged to new computer

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top