View Single Post
  #2  
Old November 1st 06, 06:54 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,330
Default Registering XLA macros / linking to buttons / making toolbars

Am Mon, 30 Oct 2006 23:29:01 -0800 schrieb Bongo:

That question would better be asked in an Excel group.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --

Hello

I have an XLA with some formatting macros.

1) When I try to link them to toolbar buttons, they don't show up in the
available macro dialog. Is there a way to register them or do something to
allow them to show up?

2) Is there a way to somehow save a toolbar with the XLA, with the buttons
pre-linked to the functions?

3) Up until now, I have been using a standard, unlinked toolbar with four
custom buttons. However, sometimes (don't know why--maybe some race
condition), when I start excel, the buttons are linked nowhere, and I need

to
manually relink all of them. If the answer is "no" to number 2, can anyone
think of why this could be happening, or how to avoid its happening?

Thanks in advance
Bongo

Ads
 

McDonalds - Pick up lines - Debt Consolidation - Your File Host - Loans