Switch ribbons programmatically
 

In Excel 2007,

Suppose you have a custom ribbon started from scratch in a workbook. Is there
a way to programmatically cause it to revert back to the default/built-in
ribbon and back again while the workbook remains open?

If so, can someone please help me code it?

Thanks!

Switch ribbons programmatically
 

when workbook with ribbon active its ribbon is visable. you have change to
another workbook with no ribbon for ribbon to change to norml

"xp" wrote in message
...
In Excel 2007,

Suppose you have a custom ribbon started from scratch in a workbook. Is
there
a way to programmatically cause it to revert back to the default/built-in
ribbon and back again while the workbook remains open?

If so, can someone please help me code it?

Thanks!

Switch ribbons programmatically
 

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 message ...
In Excel 2007,

Suppose you have a custom ribbon started from scratch in a workbook. Is there
a way to programmatically cause it to revert back to the default/built-in
ribbon and back again while the workbook remains open?

If so, can someone please help me code it?

Thanks!

Switch ribbons programmatically
 

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 message ...
In Excel 2007,

Suppose you have a custom ribbon started from scratch in a workbook. Is there
a way to programmatically cause it to revert back to the default/built-in
ribbon and back again while the workbook remains open?

If so, can someone please help me code it?

Thanks!

Switch ribbons programmatically
 

Mail me private and I send you the file

You find my mail address here
http://www.rondebruin.nl/


--

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




"xp" wrote in message ...
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 message ...
In Excel 2007,

Suppose you have a custom ribbon started from scratch in a workbook. Is there
a way to programmatically cause it to revert back to the default/built-in
ribbon and back again while the workbook remains open?

If so, can someone please help me code it?

Thanks!

Switch ribbons programmatically
 

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

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