Customised ribbon - displaying a group based on pressing a button in another group

**micklloyd** · 01-13-2012, 08:13 AM

Hi

How can I display the buttons in one group (ID = "DTGroup") on a Tab in my customised ribbon as a result of clicking a button within another group (ID = "Setup") of buttons under the same Tab.

I have hidden the DTGroup on opening the workbook (by entering the attribute "visible = false" in my XML code). I want to now show the DTGroup when the user clicks a button in the Setup group.

It used to work with CommnadBars using the "Enabled" and "Visible" properties which could be set within a procedure called by another CommandBar control.

Any help appreciated.

Mick

**OnErrorGoto0** · 01-13-2012, 08:23 AM

You would need a getVisible callback. See Ron de Bruin's MSDN article here as an example.

**micklloyd** · 01-14-2012, 11:23 AM

Hi - thanks for responding on this one too.

I have tried the Ron de Bruin fix but am having problems with it. I downloaded the file from his site and used the first part of it verbatim as he suggested. However when I have the following in my code, I get an "Invalid outside procedure" error from using Set.
<code>
'Callback for customUI.onLoad
Private Declare Sub RibbonOnLoad Lib "CByte" Alias "#116" ()
Set Rib = ribbon
End Sub
</code>

I actually tried to compile Ron's own file to see if it would work and it crashed Excel every time. It also crashed when I clicked on Enable Content after the file loaded.

Mick

**OnErrorGoto0** · 01-15-2012, 04:33 AM

Which file did you use? That code looks very strange to me - you cannot add code or an end sub to a Declare Sub statement.
Are you using 2007 or 2010? If the latter, is it 32bit or 64bit Office?

**micklloyd** · 01-15-2012, 06:21 AM

Hi -thanks again.

The file is from the getVisible.zip file downloaded from Ron's site. I can't remember exactly which one and can't now open any of the files therein to check the VBA code. Each time I click on Enable Content, Excel crashes (Error 400). I'm using Excel 2010.

Anyway, since I've learned more about the XML code attached to my file I've managed to combine other buttons in a menu so saved space on the ribbon. I've decided to have the previously hidden menu available permanently. Nonetheless, thanks very much for your assistance.

Mick

**OnErrorGoto0** · 01-15-2012, 10:21 AM

As a matter of interest, is it Excel 2010 64bit or 32bit?

**micklloyd** · 01-15-2012, 03:03 PM

32bit I believe.

**OnErrorGoto0** · 01-15-2012, 03:55 PM

Strange. I will have a look through the zip file later on and see if I can see anything strange about the workbooks. If so, it would be worth alerting the author.

Customised ribbon - displaying a group based on pressing a button in another group

LinkBack

Thread Tools

Rate This Thread

Display

Customised ribbon - displaying a group based on pressing a button in another group

Re: Customised ribbon - displaying a group based on pressing a button in another grou

Re: Customised ribbon - displaying a group based on pressing a button in another grou

Re: Customised ribbon - displaying a group based on pressing a button in another grou

Re: Customised ribbon - displaying a group based on pressing a button in another grou

Re: Customised ribbon - displaying a group based on pressing a button in another grou

Re: Customised ribbon - displaying a group based on pressing a button in another grou

Re: Customised ribbon - displaying a group based on pressing a button in another grou

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions