Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
toolbuttons and macros in excel 2007
I developed an application in excel 2003. The application incorporated use of
toolbuttons with associated macros. When opening the application we discovered that the buttons referred to a map on the memory stick, we used to transport the applicaton on. In the 2003 version this poses no problem - right click on the buttonbar and when the dialogbox appears, right click on the button and choose the relevant macro - but in the 2007 this is not possible, or is it? If so, how? -- greetings trolle |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
toolbuttons and macros in excel 2007
The UI is gone in Excel 2007. You'd have to use a macro:
CommandBars("xxx").Controls(1).OnAction = "abc" -- Jim "trolle" wrote in message ... |I developed an application in excel 2003. The application incorporated use of | toolbuttons with associated macros. | | When opening the application we discovered that the buttons referred to a | map on the memory stick, we used to transport the applicaton on. In the 2003 | version this poses no problem - right click on the buttonbar and when the | dialogbox appears, right click on the button and choose the relevant macro - | but in the 2007 this is not possible, or is it? If so, how? | | | -- | greetings | | trolle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 and macros | Excel Discussion (Misc queries) | |||
Excel 2007 and Macros | Excel Discussion (Misc queries) | |||
Macros in Excel 2007 | Excel Discussion (Misc queries) | |||
Macros in Office Excel 2007 | Excel Worksheet Functions |