How to hide Excel2007 quick access toolbar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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
 
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
 
Back
Top