Assigning Macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Having imported an earlier excel version workbook into v 2007 I have an addin
tab showing previously created buttons. These throw up errors when pressed
so I need to re-assign the macro's. It was quite simple in earlier excel
versions but I can't find how to do it in v2007.

Can anyone give me a step by step guide???
 
I don't believe there is a way to do it through the Excel 2007 UI. Your
best bet may be to make the change in an earlier Excel.

This did seem to work though if you want to try to make the change by a
macro:

CommandBars("MyWindows").Controls("Redraw Toolbar").OnAction =
"RedoWinToolbar"

--
Jim
| Having imported an earlier excel version workbook into v 2007 I have an
addin
| tab showing previously created buttons. These throw up errors when
pressed
| so I need to re-assign the macro's. It was quite simple in earlier excel
| versions but I can't find how to do it in v2007.
|
| Can anyone give me a step by step guide???
 
You must log in or register to reply here.

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

Macros assigned to Menu Items 2
Buttons re-assigned themselves to the right macro name but in Book 1
Assign Macro to Ribbon Button 6
How to call Excel add-in macro from a button… 1
How to Create a Macro to Import External Data 0
Assigned macro change 5
Assigning macro buttons to macro code in another file 2
forcing specific sheet opening upon launch of .xlsx file 4

Back
Top