how to program a button...
 

Howdy !

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

Rgds, Henrik

how to program a button...
 

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

--
HTH

Bob Phillips

"Verner Jensen, Ålborg" wrote in message
. dk...
Howdy !

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

Rgds, Henrik

how to program a button...
 

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" wrote in message
. dk...
Howdy !

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

Rgds, Henrik

how to program a button...
 

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" wrote in message
. dk...
Howdy !

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

Rgds, Henrik