Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add a Button Programatically plus code jlclyde Excel Discussion (Misc queries) 1 December 9th 08 04:29 PM
Programatically set up footer Epoh Rio[_2_] Excel Programming 2 March 5th 07 11:10 PM
Programatically Delete command button and code. DocBrown Excel Programming 3 January 20th 07 01:28 AM
How can I programatically change the caption on a button? June Macleod[_2_] Excel Programming 3 May 28th 06 04:04 PM
Programatically set ref to my DLL ricks Excel Programming 2 April 13th 04 03:08 PM


All times are GMT +1. The time now is 05:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"