View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Custom Excel Toolbars - how?

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?