R
rupert
I've followed Ron de Bruin's instructions on Excel 2007 ribbon using "Office
2007 Custom UI editor" based on the first of Ron's
samples(http://www.rondebruin.nl/xmlribbongroups.htm) and used the first
sample to assign buttons to a couple of simple macros to Custom button 1 & 2
repsectively. The VBA works fine to show/hide outline. So I cant see why the
Custom ribbon buttons wont work. No doubt I'm being thick but there seems to
be a disconnect between adding these custom button to the ribbon and actually
assigning a macro.
Sub Macro1()
ActiveWindow.DisplayOutline = False
End Sub
Sub Macro2()
ActiveWindow.DisplayOutline = True
End Sub
When I click on the buttons, I get error message saying "wrong number of
arguments or invalid property assignment". I am trying to replicate a button
missing from Excel 2007 to show/hide outline when grouping rows. Please could
you help.
2007 Custom UI editor" based on the first of Ron's
samples(http://www.rondebruin.nl/xmlribbongroups.htm) and used the first
sample to assign buttons to a couple of simple macros to Custom button 1 & 2
repsectively. The VBA works fine to show/hide outline. So I cant see why the
Custom ribbon buttons wont work. No doubt I'm being thick but there seems to
be a disconnect between adding these custom button to the ribbon and actually
assigning a macro.
Sub Macro1()
ActiveWindow.DisplayOutline = False
End Sub
Sub Macro2()
ActiveWindow.DisplayOutline = True
End Sub
When I click on the buttons, I get error message saying "wrong number of
arguments or invalid property assignment". I am trying to replicate a button
missing from Excel 2007 to show/hide outline when grouping rows. Please could
you help.