Hi,
In the process of this I had one problem... the Excel 4 sheet macros have commands that manipulate the menu system. Since 2010 uses ribbon these will obviously no longer work.
So I removed those macro lines that touched the menu system.
There is one macro which calls the File Open dialog box.
The Macro is called OpenFile and its contents are:
=OPEN?()
Now, when I go to macros and manually Run this it works and opens the dialog.
But when I try to assign this macro to the onAction of a custom ribbon button I get an error Sub or Function not defined.
Is there a workaround/fix for this? Why can my ribbons onAction event not fire the macro when I can do it manually?
thanks,
KS
In the process of this I had one problem... the Excel 4 sheet macros have commands that manipulate the menu system. Since 2010 uses ribbon these will obviously no longer work.
So I removed those macro lines that touched the menu system.
There is one macro which calls the File Open dialog box.
The Macro is called OpenFile and its contents are:
=OPEN?()
Now, when I go to macros and manually Run this it works and opens the dialog.
But when I try to assign this macro to the onAction of a custom ribbon button I get an error Sub or Function not defined.
Is there a workaround/fix for this? Why can my ribbons onAction event not fire the macro when I can do it manually?
thanks,
KS
