Excel 2007 - Personnal CommandBars

  • Thread starter Thread starter Lucky
  • Start date Start date
L

Lucky

I used to program (with VisualBasic) personal commandbars under Excel
2003 and older...

All those commandbars works fine with Excel 2007 but I don't know how
to hide the new commandbars created by Microsoft (I think they call it
Ribbon) in order to have only my personnal commandbars visible on the
top of the Excel sheet.

Can someone help me with this.

Thank you

Lucky
 
To the right of the Quick Access Toolbar is a downward pointing arrow
(Customise QAT)
Click this and select Minimize Ribbon
OR
Use CTRL+F1
best wishes
 
To the right of the Quick Access Toolbar is a downward pointing arrow
(Customise QAT)
Click this and select Minimize Ribbon
OR
Use CTRL+F1
best wishes
--
Bernard V Liengmewww.stfx.ca/people/bliengme
remove caps from email










- Afficher le texte des messages précédents -
Click to expand...

Thank you Bernard ... but what I need to do is custumize the ribbon in
order that the only toolbar visible in that file will be my personnal
toolbar.

Thanks again

Lucky
 
but what I need to do is custumize the ribbon in order that the only
That's not possible. With the ribbon you get all of it or none of it. What
you should do is recreate your menus in RibbonX, using the StartFromScratch
attribute to remove all (most anyway) of Excel's ribbon. Look at Ron's site
that Mike pointed you toward. And also:

http://msdn2.microsoft.com/en-us/office/aa905530.aspx

Yes, there is a learning curve to be ascended but the ribbon isn't going
away anytime soon so it's a good long term investment to learn about it.


--
Jim
To the right of the Quick Access Toolbar is a downward pointing arrow
(Customise QAT)
Click this and select Minimize Ribbon
OR
Use CTRL+F1
best wishes
--
Bernard V Liengmewww.stfx.ca/people/bliengme
remove caps from email










- Afficher le texte des messages précédents -
Click to expand...

Thank you Bernard ... but what I need to do is custumize the ribbon in
order that the only toolbar visible in that file will be my personnal
toolbar.

Thanks again

Lucky
 
Back
Top