how to put my own pictures onto toolbar buttons in excel 2007

[smiler44]

How do I change the button face to a picture of my own choice once I have put
a macro button on the quick access tool bar. I dont want one of the Microsoft
ones

 

[Ron de Bruin]

Hi you must use the Ms images in the QAT but there are 1871 images

Start here
http://www.rondebruin.nl/imageqat.htm

Or use this if you want it easy
http://www.rondebruin.nl/qat.htm

 

[smiler44]

Ron,
Either the instructions are wrong or I have failed to follow them but I
could not get it to work.
smiler44

 

[Shane Devenshire]

Hi,

For the basic images:

1. Press Alt+1, and choose Customize
2. Choose Macros from the Choose command from drop down
3. Find your macro on the left side, and double-click it
4. Select the new button on the right side and click the Modify button at
the bottom right.

 

[Gord Dibben]

My guess would be the latter.

Ron's instructions are always correct in my estimation.


Gord Dibben MS Excel MVP

 

[Ron de Bruin]

Hi smiler44

What is the problem ?
Let me know and I will try to help you after work

--

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

 

[smiler44]

Shane,
I have opened my Excel 2007 workbook and pressed Alt +1. Whats supposed to
happen? I don't see Customize. However I think I know where your going and
I've been there.
If this gives me one of the microsoft icons. I don't want one of thoses. I
want one of my own.
smiler44

 

[smiler44]

In that case I will try again, thank you
Smiler44

 

[smiler44]

Hi,
I follwed steps 1, 2 and 3 ok. The line Use Browse to select the add-in and
then click OK got me beat. A new window opens titled Browse. The box next to
Look In has Addins in it but there is nothing listed in the area below.
Not sure what to do, sorry.
smiler44

 

[Ron de Bruin]

Hi smiler44

Look In has Addins in it but there is nothing listed in the area below.
Not sure what to do, sorry.

Browse to the folder where you have saved the add-in and select it and press OK

--

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

 

[smiler44]

Sorry Ron, I'm still at a loss. I'm new with this so dont give up on me.
you say "Browse to the folder where you have saved the add-in and select it
and press OK"
This may sound stupid but I have not saved any add in. I created a custom
toolbar using excel 2003. the toolbar is part of the workbook. I am now using
Excel 2007.
Should I be going to where I have saved your "My Add-in.xlam" and selecting
that file?
I'm not a whizz kid so it may take a bit more explaining for me to understand.
smiler44

 

[Ron de Bruin]

You not follow the steps on this page
http://www.rondebruin.nl/imageqat.htm

But now I read this I think you better create a custom Tab
This is not easy.

Follow the basic steps on this page and download the example workbooks
http://www.rondebruin.nl/ribbon.htm

You can use your own images on a custom Ribbon Tab if you want

After you play with information above post back for more help



--

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