When True, getVisible no longer works
Correct
But maybe you can hide all tabs if you want with RibbonX and use getVisible to toggle
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Dovy" wrote in message ...
On Apr 11, 1:11 pm, "Ron de Bruin" wrote:
Mail me private and I send you the file
You find my mail address herehttp://www.rondebruin.nl/
--
Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm
"xp" wrote in ...
Hi Ron,
Thanks; the internet Nazi's here at the office are blocking my ability to
download your examples...
"Ron de Bruin" wrote:
You can hide the tabs or controls with code if you want
See the download on this page
http://www.rondebruin.nl/ribbon.htm
See point 3
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"xp" wrote in ...
In Excel 2007,
Suppose you have a customribbonstarted from scratch in a workbook. Is there
a way to programmatically cause it to revert back to the default/built-in
ribbonand back again while the workbook remains open?
If so, can someone please help me code it?
Thanks!- Hide quoted text -
- Show quoted text -
Ron de Bruin example file is great, but it works only when
startFromScratch=False. When True, getVisible no longer works. The
original post asked how to switch back to original Ribbon within a
workbook with custom Ribbon started from scratch.
The only way to toggle between custom/original ribbons when using
startFromScratch=True, is to rebuild all Mso tabs as custom tabs.
Custom tabs do respond to getVisible.
Dovy