toolbuttons and macros in excel 2007

  • Thread starter Thread starter trolle
  • Start date Start date
T

trolle

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?
 
The UI is gone in Excel 2007. You'd have to use a macro:

CommandBars("xxx").Controls(1).OnAction = "abc"

--
Jim
|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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vb code for running macro from toolbutton 1
Assigning Macros in Excel 2007 1
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1
Excel 2007 Macro 1
Excel 2007: Help creating a macro that will run Solver? 3
macros in Excel 2007 1
Macro security in Excel 2007 1
2003 Macro in Excel 2007 1

Back
Top