Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with Excel 2007 Ribbon | Setting up and Configuration of Excel | |||
Excel 2007 Ribbon | Excel Discussion (Misc queries) | |||
Ron de Bruin's instructions on Excel 2007 ribbon | Excel Programming | |||
Excel 2007 Ribbon | Excel Worksheet Functions | |||
How can I add the OneNote 2007 icon to the ribbon in Excel 2007? | Excel Discussion (Misc queries) |