How to hide Excel2007 quick access toolbar

B

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.
 
R

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top