Keyboard shortcut not working when I copy macro to another computer

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,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"telewats" wrote:

>
> 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?
>
>
> --
> telewats
> ------------------------------------------------------------------------
> telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270
> View this thread: http://www.excelforum.com/showthread...hreadid=499386
>
>