Computing.Net > Forums > Office Software > Excel 2003 - custom button

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Excel 2003 - custom button

Reply to Message Icon

Name: A Certain TH
Date: April 25, 2006 at 02:28:26 Pacific
OS: xp pro
CPU/Ram: -
Product: -
Comment:

Hi All

I have several add-ins which load with Excel. On my toolbar are a few custom buttons which refer to macros I've written and which are housed in one of the add-ins.

The problem is that (apparently randomly) Excel changes the add-in name that it thinks the macro is housed in.

To explain more clearly:
lets say I have AddInOne.xla and AddInTwo.xla

I have a custom button which refers to AddInTwo.xla!myMacro

After a few days, I'll click the button, and it will say "Macro not found.. blah blah" and when I look at the button's macro assignment, it says it refers to AddInOne.xla!myMacro


Strikes me as odd, and I can't solve it. Anyone else?

Thanks in advance!

Tom




Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Excel 2003 - custom button

Excel 2007 data bars for Excel 2003 www.computing.net/answers/office/excel-2007-data-bars-for-excel-2003/9304.html

printing multiple worksheets in excel in colo www.computing.net/answers/office/printing-multiple-worksheets-in-excel-in-colo/9395.html

saving the 2003 excel file into excel1997 www.computing.net/answers/office/saving-the-2003-excel-file-into-excel1997/9804.html