Excel 2007 : Hiding and Showing Excel 2007 Ribbon

Hi everybody,

I use the following tow VBA Codes for Hiding and Showing Excel toolbars, and they work perfectly with Excel 2003.

However, when I used them with Excel 2007, they also worked well, but once the user presses Escape Key Or Double Clicks Window Frame, the ribbon and Worksheet Menu Bar appear.

Please Login or Register  to view this content.

So, Is there any solution for that???

Best Regards,

Try this

Please Login or Register  to view this content.

Change false to true to restore

hello.

from my experience with the excel 2007 ribbon. It cannon be changed within VBA, With a quick glance at the code what is mostlikely happening is the application is displaying in fullscreen and the dblclick takes it out of fullscreen.

if you want to remove the 2007 toolbars you can use somethink like (office 2007 custon UI editor) and tell it to START FROM SCRATCH.

Andy pope has some information on his site that talks about the 2007 ribbon

hope this helps


well there you go, Roy you done it again. ill have to rember that one.

Works for me

Please Login or Register  to view this content.

Here is the link for the addin that andy wrote http://www.andypope.info/vba.htm

and another great resoruce for ribbon related stuff http://www.rondebruin.nl/ribbon.htm

what roy has posted works for me. true to show, false to hide.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save