Keyboard shortcut not working when I copy macro to another computer

  • Thread starter Thread starter telewats
  • Start date Start date
T

telewats

I created a large macro to tally information in a report. I established
a Keyboard shortcut for it, and it works great on my computer. I copied
the macro, though, and pasted in other computers and the keyboard
shortcut won't work. I established a shortcut key when I entered the
macro on the other computer. Any tips on what I can do to make the
shortcut work?
 
The short cut won't work if you copy and paste a macro.
However, while in the Visual Basic Editor, if you export the macro to a file
and then import that file to the new workbook, the shortcut will work.
This is because the shortcut is 'hidden' while you're looking at it in the
VBE and doesn't get copied with a normal copy/paste .

HTH,
 
Back
Top