<div>
I did check and an add-in with a macro assigned ti Ctrl+Z did not work but one assigned to Ctrl+Alt+A did. In any case you're welcome and I'm glad I was able to help.<br />
<br />
In <a href="https://www.experts-exchange.com/M_258447.html" rel="ugc">my profile</a> you'll find links to some articles I've written that may interest you.<br />
Marty - MVP 2009 to 2014
</div>


I did check and an add-in with a macro assigned ti Ctrl+Z did not work but one assigned to Ctrl+Alt+A did. In any case you're welcome and I'm glad I was able to help.

In my profile [https://www.experts-exchange.com/M_258447.html] you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014

<div>
<div class="content wysiwyg-content">
I created a macro with a shortcut and now need to distribute that macro to a group of people to use. &nbsp;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. &nbsp;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. &nbsp;Does saving the file as an addin break the macro shortcut key functionality?
</div>
</div>


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?

VB macro Addin

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.