PC Review


Reply
Thread Tools Rate Thread

Buttons with macro in XLA not found

 
 
=?Utf-8?B?SGFycmllIFJpYmJlcnM=?=
Guest
Posts: n/a
 
      17th Oct 2007
In Excel 2003 works everything fine. But in Excel 2007, buttons with a macro
in an XLA, are not found. All buttons must be readressed to the macro in the
XLA. Starting the XLA as an addin or started with a file, does not help. A
menu in the same XLA is working fine. Who can help me to prevent changing
hunderds of buttons. Thanks in advance.
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      17th Oct 2007
If you can live with your toolbar hiding under the Addins tab on the ribbon:

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)

=============
If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl
or
http://www.rondebruin.nl/ribbon.htm

Harrie Ribbers wrote:
>
> In Excel 2003 works everything fine. But in Excel 2007, buttons with a macro
> in an XLA, are not found. All buttons must be readressed to the macro in the
> XLA. Starting the XLA as an addin or started with a file, does not help. A
> menu in the same XLA is working fine. Who can help me to prevent changing
> hunderds of buttons. Thanks in advance.


--

Dave Peterson
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
OnTimer - The macro 'macro name' cannot be found. louieuow Microsoft Excel Programming 2 2nd Oct 2009 10:13 AM
Assigning macro buttons to macro code in another file Enz Microsoft Excel Programming 2 25th May 2009 06:44 PM
Macro buttons opening saved macro Wasabijim Microsoft Excel Misc 0 29th Apr 2009 08:39 PM
Macro cannot be found or has been disabled because of Macro settin =?Utf-8?B?SkQy?= Microsoft Word Document Management 5 15th Mar 2007 04:00 AM
Replacing macro buttons with a new set of buttons jonco Microsoft Excel Programming 3 3rd Jul 2006 01:36 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:50 PM.