Registering XLA macros / linking to buttons / making toolbars

[Guest]

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

 

[Michael Bauer [MVP - Outlook]]

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

That question would better be asked in an Excel group.