Solved

VB macro Addin

Posted on 2014-09-17
3
103 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

895 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now