Ribbon in Excel 2007

  • Thread starter Thread starter m.s.kristensen
  • Start date Start date
M

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
 
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
 
Back
Top