![]() |
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