Programatically Add a Button to the QAT?
 

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

Programatically Add a Button to the QAT?
 

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.

--
Regards,
Tom Ogilvy


"Kent" wrote:

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

Programatically Add a Button to the QAT?
 

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

--

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


"Tom Ogilvy" wrote in message ...
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.

--
Regards,
Tom Ogilvy


"Kent" wrote:

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

Programatically Add a Button to the QAT?
 

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

--

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


"Ron de Bruin" wrote in message ...
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

--

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


"Tom Ogilvy" wrote in message ...
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.

--
Regards,
Tom Ogilvy


"Kent" wrote:

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