For clarity...

I did play around with Ron's Ribbon samples in XL2007 a bit some years
back. I've recently reviewed his latest samples after installing v2010,
played around with those and concluded I'd renew interest in using
custom ribbons.

It seems to me that coding for what works in both 2007/2010 just makes
sense and so I opted for 'hooking' existing menuitems and/or
'hide/replace' built-in stuff with my own. This, of course, is with
respect to my 'dictator' apps where the entire Excel UI is modified to
the nth degree specific to what the app requires. In early versions
some user may not even realize they're working in Excel. This is harder
to disguise in the later versions, though, and so the best approach IMO
is to use 'startfromscratch'!

I'm still figuring out how to make ribbon controls 'context sensitive'
in a similar fashion as I've been doing for commandbars/popups. I have
a fairly 'bullit-proof' methodology for this using an events class that
implements a "SetMenuState" system based on passing values in a
delimited string in context to procedures and how they affect a global
glAppMode variable. Fairly complex to say the least but this
methodology works for both VB6 and VBA projects alike.

I won't be happy until I have context-sensitive things working for the
Ribbon with the same reliable consistency. I don't think it'll take
much to get it working if I can get the time/energy I need to move
things forward. Meanwhile, monopolizing the Addins tab along with all
the other UI settings I normally use is working really well for
persisting with using XLAs, and a 'dummy' XLSX for making ribbon
customizations where Excel version is = 12. This relabels the Addins
tab with gsApp_Name and sets it as the only tab visible. The
Home/Backstage tabs are modified as per app requirements!

Since my apps use their own automated instance, this persists my
commandbar/toolbar/popups without issue in all versions with needing
only simple maintenance.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion