Ribbon in Excel 2007

[m.s.kristensen]

Hey Alle

I have created an Ribbon in Excel


The Ribbon is diveded in drifrents parts(Groups)


Now I need to control if the specific Groups are Hidden/Shown by the
active.sheets in VBA


Can anybody help me?


Yours Martin Skov Kristensen

 

[Ron de Bruin]

Hi Martin

I have a example workbook on my site
http://www.rondebruin.nl/ribbon.htm

See point 3

 

[Homey]

you must do couple things

-add getVisible attribute to ribbonx for the group you want to chang visibe.
-sub named in getvisible attribute must be added to module and it must
return true or false.
-must use sheet change event to invalidate ribbon.

| Hey Alle
|
| I have created an Ribbon in Excel
|
|
| The Ribbon is diveded in drifrents parts(Groups)
|
|
| Now I need to control if the specific Groups are Hidden/Shown by the
| active.sheets in VBA
|
|
| Can anybody help me?
|
|
| Yours Martin Skov Kristensen