Home made icon buttons

Hiya

For one of the workbooks I am working on it would help if I had two toolbar/icon buttons that changed the text colour. I know there is the button that drops down the colour... but I'm lazy and if I'm switching between colours it would be easier if I had one that made the text green and one that made it blue.

So.. I'm completely new to this... How do I go about creating an icon with the macro attached to it.

Also, I will be creating a new version of this spreadsheet every month but I will still need the icons working so I need them to be in my toolbar all the time.

I have a toolbar that I've made that has a few bits I use regularly so it would be good if I could add them to that one.

Thanks heaps

I can tell you the easy part.

right click on the menu bar or on one of the open toolbars (standard, formatting, whatever) to see the list of all toolbars supplied with the Excel program.
Go to the very bottom of the list and left click "customize".
The customize window will open with the "commands" tab selected.
On the left side of the window, slide the scroll bar down to the bottom.
Left click the "macros" item, 3rd from the bottom.
The right side of the window will show 2 items - "Custom Menu Item" and "Custom Button".
Left click and drag the "Custom Button" (yellow smiley face) to one of your open toolbars.
Do NOT close the "Customize" window.
Right click the new smiley face icon on your toolbar and you will see options to rename, change or edit (create your own) the button image, and to assign a macro to the button.
If you want to choose green and blue text, you need two buttons.
After you do all that you can close the "Customize" window.

I believe the buttons will remain functional on the command bar for any workbook you copy from the original, but I won't swear to that.

I hope that helps.

Conor

this is brilliant, thank you

you do realise it just leads to more questions though..

OK, I need other people to have these macros. I've saved them in a personal macro excel file. Can I share this with people? Do I have to create new macro buttons or is there a way of putting the whole toolbar on the spreadsheet so that whoever opens it, on whatever computer they can use these buttons?

Thanks again!!

Thank you, but my input was fairly minimal. I'm glad it helped, but save the "brilliants" for the moderators and people who REALLY know this stuff. As it is, I have reached the limit of my expertise wrt your questions. I'm sure a moderator or other expert will pick it up from here. I actually want to know the answers to the questions you pose, also.

Good luck.

Conor

LOL!!! you still helped me heaps!!

So.... *bump* does anyone know the answer to this question?

I've made some toolbar buttons and applied "home-built" macros to them.. but I need at least 2 other people to be able to use these on a specific spreadsheet.

The macros are currently stored on a separate macro sheet.

I will be creating a new version of this spreadsheet every month.

Do I have to create them on both of the other computers or is there a way of copying them over.

thanks heaps

Heather