Solved

VB macro Addin

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

Accepted Solution

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

Author Closing Comment

by:Rrave26
Comment Utility
Thanks.
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This is pretty cool.  The purpose of this VB Script is to help you document where JAR (Java ARchive) files and specifically java class files are located so that you can address issues seen with a client or that you can speak intelligently with a dev…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

763 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

12 Experts available now in Live!

Get 1:1 Help Now