How to hide Excel2007 quick access toolbar

[ben]

Hi all:
I want to hide the quick access toolbar in Excel2007.
In XML:
My way is:
<qat visible="false" />
But it seems no any effect.

Thanks a lot.

 

[Rick Rothstein \(MVP - VB\)]

Hi all:

I want to hide the quick access toolbar in Excel2007.
In XML:
My way is:
<qat visible="false" />
But it seems no any effect.

Probably not what you want, but you can click the down arrow to the right of
the QAT and uncheck all of the items. You will still be left with the down
arrow, but nothing else.

Rick

 

[ben]

I need to hide the quick access toolbar by XML or code, not manually.
Thanks
Ben

 

[Rick Rothstein \(MVP - VB\)]

Yeah, I realized that afterwards.

The closest thing I could find is to hide the Ribbon which hides the QAT
also, but I couldn't find anything about hiding the QAT by itself. Here is
how to hide the entire Ribbon...

Application.ExecuteExcel4Macro("SHOW.TOOLBAR(""Ribbon"",FALSE)")

This code snippet was posted by "Sam" at this link...

http://smurfonspreadsheets.wordpress.com/2007/08/20/office-2007-beta-service-pack-1-rumoured/

Perhaps you can play around with it and come up with something for us.

Rick

 

[Ron de Bruin]

See also
http://www.rondebruin.nl/ribbon.htm