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
|