ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Ron de Bruin's instructions on Excel 2007 ribbon (https://www.excelbanter.com/excel-programming/423420-ron-de-bruins-instructions-excel-2007-ribbon.html)

rupert

Ron de Bruin's instructions on Excel 2007 ribbon
 
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.


All times are GMT +1. The time now is 07:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com