Excel 2007 Macros (Create macro icon)

[ma7bd]

Hi People,

I have a list of Macros in Excel 2007. (View, Macros, Then choose your macro from the workbook)
I want to create an Icon for the macro list old excel!)
This will save me from going through all the macro's stored everytime I want to use one.
Is there anyway of doing this, can anyone help.
Thanks,
Leo

 

[MarcLodge]

Hi Leo,
Have a look at this page:

http://www.mrexcel.com/archive/VBA/658.html

Seems to do what you are asking, although it is for Excel 2000.

Marc

 

[GlennUK]

Hi Leo,

look at the section headed "Modifying the Ribbon" in this article:

http://www.jkp-ads.com/Articles/DistributeMacro03.asp

I haven't tried this yet ( I don't have Excel 2007 today ), and it looks very complicated, but it's the only article I've seen so far that covers this, and I've been reading all I can about Excel 2007 for a long time.



Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[ma7bd]

Thanks guys... 2003 is pretty simple. It's 2007 im having a problem with.
Microsoft could leave these things alone could they!! aaaggghhh!!!
Thanks for trying but anyone got any tips for 2007?

 

[TonyJollans]

I don't understand the question. When you talk about using Icons for macros, do you mean on a toolbar? And if so, do you not see the same icons on the AddIns tab in 2007?

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[Lilliabeth]

It sounds to me like you just clicked the link, but didn't read GlennUK's post. You might want to try that.

--Lilliabeth

 

[GlennUK]

I have to agree with Lilliabeth, it doesn't sound like you read what I said ... or have you tried it in some way?

Cheers, Glenn.

Beauty is in the eye of the beerholder.