Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm experimenting with Ribbons in 2010, and apparrently I must create
the macro with '(Control As IRibbonControl)' to be able to call the macro from a ribbon-button. But this gives an a compile error in XL2003. My quick test -macro is: Sub Show_A1(Control As IRibbonControl) If Range("A1").Value = "" Then MsgBox "Cell A1 is empty!" Else MsgBox "Cell A1 = " & Range("A1").Value End If End Sub How to make macros work in both XL2003 and XL2010 without compiler-error in either??? CE |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Make 2007 macros work in 2003 | Excel Discussion (Misc queries) | |||
Make 2 Macros Work as 1 | Excel Programming | |||
how can i make macros to work when in tools, costumize and option. | Excel Worksheet Functions | |||
make macros (sub) work for add-in? | Excel Programming | |||
How to make the macros work for different Excel versions? | Excel Programming |