View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Switch ribbons programmatically

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