---

Howdy !

Is it possible to have a button on a menubar calling a function in an .xla?

Rgds, Henrik

---

Yes, just create it within the workbook_Open event of the xla.

--
HTH

Bob Phillips

"Verner Jensen, Ålborg" <java@ofir.dk> wrote in message
news:427f5a7b$0$78283$157c6196@dreader1.cybercity.dk...
> Howdy !
>
> Is it possible to have a button on a menubar calling a function in an
..xla?
>
> Rgds, Henrik
>
>

---

If you assign the onaction property of the button to the code in the xla.
It can also be done manually although you would not be able to select it
from the choices in the dialog box - you could still type in the reference.

--
Regards,
Tom Ogilvy

"Verner Jensen, Ålborg" <java@ofir.dk> wrote in message
news:427f5a7b$0$78283$157c6196@dreader1.cybercity.dk...
> Howdy !
>
> Is it possible to have a button on a menubar calling a function in an
..xla?
>
> Rgds, Henrik
>
>

---

This file might be a help:

It contains a workbook that shows how to create an interactive add-in
controlled by a toolbar.
The toolbar is created when the add-in is loaded, and deleted when the
add-in is closed.

http://www.bygsoftware.com/examples/excel_addin.htm
The code is open and commented.


--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"Verner Jensen, Ålborg" <java@ofir.dk> wrote in message
news:427f5a7b$0$78283$157c6196@dreader1.cybercity.dk...
> Howdy !
>
> Is it possible to have a button on a menubar calling a function in an
..xla?
>
> Rgds, Henrik
>
>