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?


--
telewats
------------------------------------------------------------------------
telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270
View this thread: http://www.excelforum.com/showthread...hreadid=499386

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

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