I created a macro using vba using Excel 2010. I then needed to make it available for everyone on my team by turning it into an addin.
So, I took my macro
- and opened a new workbook
- pasted the code in it from the macro
- then saved it as an .xlam file
- then added it in as an addin to my excel spreadsheet, so it's initialized and shows up under the addins button with a checkmark next to the name.
I thought I did it correctly, however, when I try the ctrl key + "the letter I used", which is the keystroke combination I used when I created the addin, nothing happens?
I'm a newbie with the excel vba stuff, so is this the correct way to create an addin for others to use?
Creating an addin for Excel 2010 and then making a ribbon entry in the toolbar is too complicated for what I was trying to do. It also seems that you can't use key combinations to run an addin. So, I opted for using a global macro and that worked.
Here is a tutorial that I followed to create a global macro.