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.

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

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

"Rick Rothstein (MVP - VB)" wrote:

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

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(""Rib bon"",FALSE)")

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

http://smurfonspreadsheets.wordpress...ck-1-rumoured/

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

Rick


"ben" wrote in message
...
I need to hide the quick access toolbar by XML or code, not manually.
Thanks
Ben

"Rick Rothstein (MVP - VB)" wrote:

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

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Rick Rothstein (MVP - VB)" wrote in message ...
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