Ribbon in Excel 2007
 

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

Ribbon in Excel 2007
 

Hi Martin

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

See point 3


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




" wrote in message
...
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

Ribbon in Excel 2007
 

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.

" wrote in message
...
| 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