I have an excel addin file (.xlam). It contains one funtion & one macro. I want to create installer/uninstaller with home-ribbon button to run my macro. My code works fine but I dont know to to make extra tab visible with a button to run my macro. I am a novice. Experts please help. This installer should work on Excel 2007, 2010, 2013 and later. Thanks in advance.
Asked
Active
Viewed 459 times
-1
-
I want ribbon tab & button through installer because I will distribute this file to 100 of my colleagues to use my macro with ease via a button. – maninder singh Apr 03 '16 at 16:44
-
1I'm voting to close this question as off-topic because this is neither a code-writing nor tutorial service – jonrsharpe Apr 03 '16 at 16:48
1 Answers
1
I assume this is what you are looking for: http://www.rondebruin.nl/win/s2/win001.htm
You can find instructions on how to create Ribbon-buttons manually and a utility that does it for you.
The XLAM file itself will be installed as normal, but you can indeed make the macro's available with their own Ribbon-buttons and menu's.
Courtesy to Ron de Bruin, as usual.
Rik Sportel
- 2,661
- 1
- 14
- 24