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

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