Hi there,

Has anyone some experience with modifying the QAT ribbon using VBA and XML
code? If yes, is there some demo code/workbook available?

Thanks

MrT

I wanted to do that as well but it is not possible/allowed to be done :(

Look at http://msdn2.microsoft.com/en-us/library/ms406047.aspx :

The Quick Access Toolbar. Can be authored only in start from scratch mode.

Hi Stefan,

Thanks for your reply. I'm desperate ... what does "only in start from
scratch mode" mean? I reviewed the information on the Ribbons on the MS pages
and did not understand much of their stuff.

They say "If set to True, the Ribbon hides built-in main tabs and displays a
minimal File menu." What's the use of this mode ??? As I'm not able to do a
demo project for ribbons in VBA, I cannot even do trial and error tests.

It looks that things got much more complex than they were.

I must say, that I'm a big fan of Excel, but I've been very disapointed so
far by Excel 2007, except by the inscrease of the number of columns/rows. We
reported several bugs/problems that are still there in the latest release.
And the documents released so far are very very very techy, even for a techy
like me.

Cheers,

MrT

"StefanKZVB" wrote:

I wanted to do that as well but it is not possible/allowed to be done :(

Look at http://msdn2.microsoft.com/en-us/library/ms406047.aspx :

The Quick Access Toolbar. Can be authored only in start from scratch mode.

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.

What is it you want to do exactly?

--
Jim
"MrT" wrote in message
...
| Hi Stefan,
|
| Thanks for your reply. I'm desperate ... what does "only in start from
| scratch mode" mean? I reviewed the information on the Ribbons on the MS
pages
| and did not understand much of their stuff.
|
| They say "If set to True, the Ribbon hides built-in main tabs and displays
a
| minimal File menu." What's the use of this mode ??? As I'm not able to do
a
| demo project for ribbons in VBA, I cannot even do trial and error tests.
|
| It looks that things got much more complex than they were.
|
| I must say, that I'm a big fan of Excel, but I've been very disapointed so
| far by Excel 2007, except by the inscrease of the number of columns/rows.
We
| reported several bugs/problems that are still there in the latest release.
| And the documents released so far are very very very techy, even for a
techy
| like me.
|
| Cheers,
|
| MrT
|
| "StefanKZVB" wrote:
|
| I wanted to do that as well but it is not possible/allowed to be done :(
|
| Look at http://msdn2.microsoft.com/en-us/library/ms406047.aspx :
|
| The Quick Access Toolbar. Can be authored only in start from scratch
mode.
|
|

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

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
|