Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning Macros
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??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning Macros
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 "barrowhill" wrote in message ... | 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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning Macros | Excel Worksheet Functions | |||
Assigning macros | Excel Discussion (Misc queries) | |||
assigning macros | Excel Discussion (Misc queries) | |||
assigning macros | Excel Programming | |||
Assigning Macros | Excel Programming |