Is it possible to build multiple custom Excel toolbars and completely remove
the ribbon?

Before anyone tells me 'try it - you may like it!', please read the following:

In my company, we use Excel as a meeting facilitation tool, and have built a
customized workbook complete with templates we use while conducting
workshops. This allows us to conduct very fluid workshops with real-time
on-screen data capture, and to provide our customers with Excel-based
workshop deliverables within minutes of closing our workshop. In order to
minimize the 'behind the curtiain' processes that would normally require
multiple clicks, we have built a set of about 50 specific macro-enabled
toolbar buttons to automate our tasks. This allows us to drive the workshop
rather than drive our spreadsheets. In Excel 2003, we completely hide the
standard and formatting toolbars, and instead use two custom-built bars.

There is nothing in the Ribbon that empowers us in the way that our
one-click toolbars do. Our workshop participants rarely see the machinations
of what we're doing, because we have refined and automated our process well.
We facilitate workshops for a living - 52 weeks a year. Upgrading to Office
2007 has destroyed our ability to use our #1 toolset, and eliminates the
competitive advantage that we built for ourselves. I simply want to build my
own toolbars and have the interface that I want, and I want to eliminate the
Ribbon altogether. Can I do it?

Try this suggestion from FSt1. I also have not used this.

see this site
http://in.geocities.com/shahshaileshs/
down at the bottom.
i do not have 2007 and have not used this. i just ran across it while doing
research on 2007.

Regards
FSt1


Gord Dibben MS Excel MVP

On Wed, 1 Apr 2009 10:05:03 -0700, Chris D. <Chris
wrote:

Is it possible to build multiple custom Excel toolbars and completely remove
the ribbon?

Before anyone tells me 'try it - you may like it!', please read the following:

In my company, we use Excel as a meeting facilitation tool, and have built a
customized workbook complete with templates we use while conducting
workshops. This allows us to conduct very fluid workshops with real-time
on-screen data capture, and to provide our customers with Excel-based
workshop deliverables within minutes of closing our workshop. In order to
minimize the 'behind the curtiain' processes that would normally require
multiple clicks, we have built a set of about 50 specific macro-enabled
toolbar buttons to automate our tasks. This allows us to drive the workshop
rather than drive our spreadsheets. In Excel 2003, we completely hide the
standard and formatting toolbars, and instead use two custom-built bars.

There is nothing in the Ribbon that empowers us in the way that our
one-click toolbars do. Our workshop participants rarely see the machinations
of what we're doing, because we have refined and automated our process well.
We facilitate workshops for a living - 52 weeks a year. Upgrading to Office
2007 has destroyed our ability to use our #1 toolset, and eliminates the
competitive advantage that we built for ourselves. I simply want to build my
own toolbars and have the interface that I want, and I want to eliminate the
Ribbon altogether. Can I do it?

Thank you for your quick reply, but no, this will not solve our problem. We
don't need the 'standard' or 'formatting' toolbars. We have 52 custom-built
excel macro toolbar buttons that we created ourselves, and we've placed them
strategically on top-border and left-border toolbars.

"Gord Dibben" wrote:

Try this suggestion from FSt1. I also have not used this.

see this site
http://in.geocities.com/shahshaileshs/
down at the bottom.
i do not have 2007 and have not used this. i just ran across it while doing
research on 2007.

Regards
FSt1


Gord Dibben MS Excel MVP

On Wed, 1 Apr 2009 10:05:03 -0700, Chris D. <Chris
wrote:

Is it possible to build multiple custom Excel toolbars and completely remove
the ribbon?

Before anyone tells me 'try it - you may like it!', please read the following:

In my company, we use Excel as a meeting facilitation tool, and have built a
customized workbook complete with templates we use while conducting
workshops. This allows us to conduct very fluid workshops with real-time
on-screen data capture, and to provide our customers with Excel-based
workshop deliverables within minutes of closing our workshop. In order to
minimize the 'behind the curtiain' processes that would normally require
multiple clicks, we have built a set of about 50 specific macro-enabled
toolbar buttons to automate our tasks. This allows us to drive the workshop
rather than drive our spreadsheets. In Excel 2003, we completely hide the
standard and formatting toolbars, and instead use two custom-built bars.

There is nothing in the Ribbon that empowers us in the way that our
one-click toolbars do. Our workshop participants rarely see the machinations
of what we're doing, because we have refined and automated our process well.
We facilitate workshops for a living - 52 weeks a year. Upgrading to Office
2007 has destroyed our ability to use our #1 toolset, and eliminates the
competitive advantage that we built for ourselves. I simply want to build my
own toolbars and have the interface that I want, and I want to eliminate the
Ribbon altogether. Can I do it?

There are examples on this page to hide the Ribbon
http://www.rondebruin.nl/ribbon.htm

If you not use a Excel 2007 file you can't use RibbonX.
You can use this then

You can use this VBA example posted by Jim Rech to Hide/Show the whole ribbon.
Sub HideRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
End Sub


Sub ShowRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
End Sub


--

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




"Chris D." wrote in message ...
Thank you for your quick reply, but no, this will not solve our problem. We
don't need the 'standard' or 'formatting' toolbars. We have 52 custom-built
excel macro toolbar buttons that we created ourselves, and we've placed them
strategically on top-border and left-border toolbars.

"Gord Dibben" wrote:

Try this suggestion from FSt1. I also have not used this.

see this site
http://in.geocities.com/shahshaileshs/
down at the bottom.
i do not have 2007 and have not used this. i just ran across it while doing
research on 2007.

Regards
FSt1


Gord Dibben MS Excel MVP

On Wed, 1 Apr 2009 10:05:03 -0700, Chris D. <Chris
wrote:

Is it possible to build multiple custom Excel toolbars and completely remove
the ribbon?

Before anyone tells me 'try it - you may like it!', please read the following:

In my company, we use Excel as a meeting facilitation tool, and have built a
customized workbook complete with templates we use while conducting
workshops. This allows us to conduct very fluid workshops with real-time
on-screen data capture, and to provide our customers with Excel-based
workshop deliverables within minutes of closing our workshop. In order to
minimize the 'behind the curtiain' processes that would normally require
multiple clicks, we have built a set of about 50 specific macro-enabled
toolbar buttons to automate our tasks. This allows us to drive the workshop
rather than drive our spreadsheets. In Excel 2003, we completely hide the
standard and formatting toolbars, and instead use two custom-built bars.

There is nothing in the Ribbon that empowers us in the way that our
one-click toolbars do. Our workshop participants rarely see the machinations
of what we're doing, because we have refined and automated our process well.
We facilitate workshops for a living - 52 weeks a year. Upgrading to Office
2007 has destroyed our ability to use our #1 toolset, and eliminates the
competitive advantage that we built for ourselves. I simply want to build my
own toolbars and have the interface that I want, and I want to eliminate the
Ribbon altogether. Can I do it?

Again, thanks for the quick response.

It looks like you have provided me with plenty of reading, and I'll have to
digest this later on and try it out.

I was hoping that I could do this within the confines of Excel, rather than
having to download a third-party tool to modify it. (History tells me that
messing with things rarely makes them less kludgy.) I guess you can chalk me
up in the list of people who just plain don't like the new interface - and
I've always been a Microsoft fan. It is quite disappointing that the
developers chose to ignore our needs and wants, and instead chose to
pre-suppose what is best for us. Sounds like more change we can believe in.
:(

"Ron de Bruin" wrote:

There are examples on this page to hide the Ribbon
http://www.rondebruin.nl/ribbon.htm

If you not use a Excel 2007 file you can't use RibbonX.
You can use this then

You can use this VBA example posted by Jim Rech to Hide/Show the whole ribbon.
Sub HideRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
End Sub


Sub ShowRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
End Sub


--

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




"Chris D." wrote in message ...
Thank you for your quick reply, but no, this will not solve our problem. We
don't need the 'standard' or 'formatting' toolbars. We have 52 custom-built
excel macro toolbar buttons that we created ourselves, and we've placed them
strategically on top-border and left-border toolbars.

"Gord Dibben" wrote:

Try this suggestion from FSt1. I also have not used this.

see this site
http://in.geocities.com/shahshaileshs/
down at the bottom.
i do not have 2007 and have not used this. i just ran across it while doing
research on 2007.

Regards
FSt1


Gord Dibben MS Excel MVP

On Wed, 1 Apr 2009 10:05:03 -0700, Chris D. <Chris
wrote:

Is it possible to build multiple custom Excel toolbars and completely remove
the ribbon?

Before anyone tells me 'try it - you may like it!', please read the following:

In my company, we use Excel as a meeting facilitation tool, and have built a
customized workbook complete with templates we use while conducting
workshops. This allows us to conduct very fluid workshops with real-time
on-screen data capture, and to provide our customers with Excel-based
workshop deliverables within minutes of closing our workshop. In order to
minimize the 'behind the curtiain' processes that would normally require
multiple clicks, we have built a set of about 50 specific macro-enabled
toolbar buttons to automate our tasks. This allows us to drive the workshop
rather than drive our spreadsheets. In Excel 2003, we completely hide the
standard and formatting toolbars, and instead use two custom-built bars.

There is nothing in the Ribbon that empowers us in the way that our
one-click toolbars do. Our workshop participants rarely see the machinations
of what we're doing, because we have refined and automated our process well.
We facilitate workshops for a living - 52 weeks a year. Upgrading to Office
2007 has destroyed our ability to use our #1 toolset, and eliminates the
competitive advantage that we built for ourselves. I simply want to build my
own toolbars and have the interface that I want, and I want to eliminate the
Ribbon altogether. Can I do it?

The Ribbon is the result from customer feedback.
It is not so bad as you think

--

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




"Chris D." wrote in message ...
Again, thanks for the quick response.

It looks like you have provided me with plenty of reading, and I'll have to
digest this later on and try it out.

I was hoping that I could do this within the confines of Excel, rather than
having to download a third-party tool to modify it. (History tells me that
messing with things rarely makes them less kludgy.) I guess you can chalk me
up in the list of people who just plain don't like the new interface - and
I've always been a Microsoft fan. It is quite disappointing that the
developers chose to ignore our needs and wants, and instead chose to
pre-suppose what is best for us. Sounds like more change we can believe in.
:(

"Ron de Bruin" wrote:

There are examples on this page to hide the Ribbon
http://www.rondebruin.nl/ribbon.htm

If you not use a Excel 2007 file you can't use RibbonX.
You can use this then

You can use this VBA example posted by Jim Rech to Hide/Show the whole ribbon.
Sub HideRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
End Sub


Sub ShowRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
End Sub


--

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




"Chris D." wrote in message ...
Thank you for your quick reply, but no, this will not solve our problem. We
don't need the 'standard' or 'formatting' toolbars. We have 52 custom-built
excel macro toolbar buttons that we created ourselves, and we've placed them
strategically on top-border and left-border toolbars.

"Gord Dibben" wrote:

Try this suggestion from FSt1. I also have not used this.

see this site
http://in.geocities.com/shahshaileshs/
down at the bottom.
i do not have 2007 and have not used this. i just ran across it while doing
research on 2007.

Regards
FSt1


Gord Dibben MS Excel MVP

On Wed, 1 Apr 2009 10:05:03 -0700, Chris D. <Chris
wrote:

Is it possible to build multiple custom Excel toolbars and completely remove
the ribbon?

Before anyone tells me 'try it - you may like it!', please read the following:

In my company, we use Excel as a meeting facilitation tool, and have built a
customized workbook complete with templates we use while conducting
workshops. This allows us to conduct very fluid workshops with real-time
on-screen data capture, and to provide our customers with Excel-based
workshop deliverables within minutes of closing our workshop. In order to
minimize the 'behind the curtiain' processes that would normally require
multiple clicks, we have built a set of about 50 specific macro-enabled
toolbar buttons to automate our tasks. This allows us to drive the workshop
rather than drive our spreadsheets. In Excel 2003, we completely hide the
standard and formatting toolbars, and instead use two custom-built bars.

There is nothing in the Ribbon that empowers us in the way that our
one-click toolbars do. Our workshop participants rarely see the machinations
of what we're doing, because we have refined and automated our process well.
We facilitate workshops for a living - 52 weeks a year. Upgrading to Office
2007 has destroyed our ability to use our #1 toolset, and eliminates the
competitive advantage that we built for ourselves. I simply want to build my
own toolbars and have the interface that I want, and I want to eliminate the
Ribbon altogether. Can I do it?