VB macro Addin
Posted on 2014-09-17
I created a macro with a shortcut and now need to distribute that macro to a group of people to use. I saved the macro in a new spreadsheet as an xlsm file and then sent it to a test subject and had him save it as an XLAM file, addin. If you run the macro from the developers tab it runs just fine, but if I try to use the shortcut key stroke, cntrl-z which was set up when I wrote the macro, it doesn't work. Does saving the file as an addin break the macro shortcut key functionality?