Adding buttons with Macros assinged to new computer

tunterbrink · External Since: Aug 02, 2007 Posts: 1

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?

Gord Dibben · External Since: Feb 23, 2004 Posts: 8800

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

On Thu, 2 Aug 2007 07:16:01 -0700, tunterbrink
<tunterbrink.RemoveThis@discussions.microsoft.com> wrote:

>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 · External Since: Jul 08, 2005 Posts: 15610

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)

tunterbrink wrote:
>
> 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