Solved

VB macro Addin

Posted on 2014-09-17
3
104 Views
Last Modified: 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?
0
Comment
Question by:Rrave26
  • 2
3 Comments
 
LVL 46

Accepted Solution

by:
Martin Liss earned 500 total points
ID: 40329339
Probably, but in any case Ctrl+Z is "Undo" so you probably want to choose a different shortcut.
0
 

Author Closing Comment

by:Rrave26
ID: 40329344
Thanks.
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 40329364
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 you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question