Home |
Search |
Today's Posts |
#1
Posted to dk.edb.programpakker.ms-office,microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
how to program a button...
Howdy !
Is it possible to have a button on a menubar calling a function in an .xla? Rgds, Henrik |
#2
Posted to dk.edb.programpakker.ms-office,microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to dk.edb.programpakker.ms-office,microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to dk.edb.programpakker.ms-office,microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create a macro button to exit a program | Excel Worksheet Functions | |||
program tab button | Excel Discussion (Misc queries) | |||
program tab button | Excel Worksheet Functions | |||
Program button appearance | Setting up and Configuration of Excel | |||
running a command button from a program | Excel Programming |