View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech[_2_] Jim Rech[_2_] is offline
external usenet poster
 
Posts: 533
Default 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