Programatically Add a Button to the QAT?

[Kent]

Three questions:

1) Can you programticaly add a button to the QAT in Excel 2007?
2) Can you progrnatically enable/disable QAT buttons?
3) Can you programatically hide the ribbon?

Thanks in advance,
Kent

 

[Tom Ogilvy]

I haven't worked with xl2007, but Ron de Bruin has written quite a bit about
it:

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

also look at the links at the bottom of the page. Two are to his own site
and I believe address modifying the QAT.

 

[Ron de Bruin]

Go to this link (must add it also to my site)
http://www.oaltd.co.uk/Excel2007ProgRef/Default.htm

You can read the ribbon chapter

Great book

 

[Ron de Bruin]

I add the link to Excel 2007 VBA Programmer's Reference on my ribbon page