I understand. It would make it clearer if you could add this on the online
doc.

Me?<g

Simply add a button to the QAT that allows me to open/close a macro.

While you can do this manually it cannot be done by macro. There is no
macro interface for modifying the QAT.

The best you can do is, I believe, to settle for a 2-click access to your
macro. You could achieve this by first adding (manually) "Menu Commands" to
the QAT. Then if you run a macro that adds a button to any built-in Excel
menu, it will automatically be added to "Menu Commnds". E.g.:

With CommandBars("File").Controls.Add(msoControlButton, , , , True)
.Caption = "MyBtn"
.OnAction = "MyMacro"
End With

--
Jim
"MrT" wrote in message
...
| Hi Jim,
|
| Thanks for your reply.
|
| What's the use of this mode ???
|
| It's for developers who use Excel as an application platform. They
| sometimes want to remove all Excel's built-in menus, etc. and replace
them
| with their own.
|
| I understand. It would make it clearer if you could add this on the online
| doc.
|
| What is it you want to do exactly?
|
| Simply add a button to the QAT that allows me to open/close a macro. This
is
| the best way to have it one click away anytime.
|
| With version 2003 I had that available in the Standard commanbar on the
4rth
| position.
|
| Regards,
|
| MrT
|