Add Macro Icon to quick access vai vba

[gint3232]

Hi Everyone,

Is there a way of adding an icon to run a macro, using vba onto the quick access toolbar,

I know you can manually do it, but I wish to add it via VBA if that's possible, I can't find any discussions with any solutions as yet!

Thanks for reading

 

[RoryA]

No, not easily. The QAT is really for the user, not developers, who should use the Ribbon.

 

[gint3232]

No, not easily. The QAT is really for the user, not developers, who should use the Ribbon.

If it can be done, I'd really like to know how as It needs to be done in this particular situation..as some user struggle with installing manually.

 

[RoryA]

Why can’t you use the Ribbon?

To use the QAT you will have to locate the user’s Excel.Officeui file, parse the XML in it, figure out where you intend to put the button, add the relevant XML, save the file, then restart Excel.

 

[gint3232]

Why can’t you use the Ribbon?

To use the QAT you will have to locate the user’s Excelui file, parse the XML in it, figure out where you intend to put the button, add the relevant XML, save the file, then restart Excel.

Thanks, any ideas on how to achieve this in the Ribbon then??

 

[RoryA]

Yes - have a read of this: http://www.rondebruin.nl/win/section2.htm

 

[gint3232]

Yes - have a read of this: http://www.rondebruin.nl/win/section2.htm

thanks for this ref to the URL ..I am sure this will suit me very well, Many thanks