LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Excel 2007 Ribbon Ayo Setting up and Configuration of Excel 2 November 6th 09 05:13 AM
Excel 2007 Ribbon Annette[_3_] Excel Discussion (Misc queries) 4 August 25th 09 02:39 PM
Ron de Bruin's instructions on Excel 2007 ribbon Andy Pope Excel Programming 0 February 4th 09 04:06 PM
Excel 2007 Ribbon Clay Excel Worksheet Functions 2 September 3rd 08 09:51 AM
How can I add the OneNote 2007 icon to the ribbon in Excel 2007? Todd Excel Discussion (Misc queries) 6 February 14th 08 11:22 PM


All times are GMT +1. The time now is 05:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"