Prev: Autocomplete date for cell based on other cell values
Next: Macro Help - Insert row/copy based on criteria
From: Chet on 6 Apr 2010 12:57
I am trying to find if it is possible to add a custom (a button that I
created myself) button to the Excel 2010 quick access toolbar?

I have a lot of program code that I want to initiate and run quickly
with one click from the toolbar. I don't want to use one of the own
the pre-existing button images that comes with Excel 2010 because I
want to use a custom icon button that will give me a better idea of
the function that I am trying to perform with this macro code.

Is there any easy way to do this? In Excel 2003 it was very easy to
add a custom (that I created) button to any toolbar and then associate
a macro or program code with that and then move it anywhere you wanted
on the toolbar in question.
Chet
From: Ron de Bruin on 6 Apr 2010 17:27
In 2007 you can do this
http://www.rondebruin.nl/imageqat.htm

But only 1871 built-in images

I not test it in 2010 so I not know if it is changed
Why not make your own Ribbon tab ???


--

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



"Chet" <chetshannon(a)gmail.com> wrote in message news:1a32428b-bdce-45c3-911d-84c8653df51d(a)g10g2000yqh.googlegroups.com...
> I am trying to find if it is possible to add a custom (a button that I
> created myself) button to the Excel 2010 quick access toolbar?
>
> I have a lot of program code that I want to initiate and run quickly
> with one click from the toolbar. I don't want to use one of the own
> the pre-existing button images that comes with Excel 2010 because I
> want to use a custom icon button that will give me a better idea of
> the function that I am trying to perform with this macro code.
>
> Is there any easy way to do this? In Excel 2003 it was very easy to
> add a custom (that I created) button to any toolbar and then associate
> a macro or program code with that and then move it anywhere you wanted
> on the toolbar in question.
> Chet
From: Chet on 6 Apr 2010 21:38
Yeah I can make my own ribbon tab but can I add my own customized
buttons to it? (I mean buttons that I created myself to represent the
function the code will perform.)... Chet
From: Ron de Bruin on 7 Apr 2010 10:16
Yes you can

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

In the RibbonX Tips part there is a example for your own icon


See also
http://www.rondebruin.nl/getimage.htm




--

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



"Chet" <chetshannon(a)gmail.com> wrote in message news:00ddc942-caf2-4a1e-b950-b5e4ca02f804(a)5g2000yqj.googlegroups.com...
> Yeah I can make my own ribbon tab but can I add my own customized
> buttons to it? (I mean buttons that I created myself to represent the
> function the code will perform.)... Chet
 | 
Pages: 1
Prev: Autocomplete date for cell based on other cell values
Next: Macro Help - Insert row/copy based on criteria