I have created certain Macros. By customizing the ribbon ,i converted the Macros into buttons.
I saved the file as an add-in (.xlam). Now, when i send the file to other people, I shall tell them to copy the file to XLstart folder
When they open their excel,I want my custom ribbon(macro buttons) to appear in their excel.However, I am failing to do so. The macros book is transferred.However,the custom ribbons/buttons i created for macros, don't transfer.Is there any standard approach to do so.
I would really appreciate if could get some source for any standard approach or reference article for sharing custom local ribbons to other PCs.
Best Answer
Recommend that you simply go to the Developer tab and insert buttons on a Worksheet -- which DOES transfer from machine to machine and not worry about using the ribbon.
An additional advantage is that you have a lot more room to explain what the button does.