how to program a button...

[Verner Jensen, Ålborg]

Howdy !

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

Rgds, Henrik

 

[Bob Phillips]

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

 

[Tom Ogilvy]

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.

 

[Andy Wiggins]

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