Find Keyboard shortcut in a macro
 

Good afternoon;
I have a slight problem with the Copy and Paste keyboard shortcut on my work
computer. It seems that after a couple of "cntrl copy" and "cntrl paste"
operations on a spreadsheet, Excel wants to paste an image of the
spreadsheet in the cell rather then the cell values or formula to be pasted.
I was told earlier that one of my macros may be using the "cntrl paste"
shortcut on the keyboard to perform another function. I have almost 200
macros.
Is there an easy way to identify the shortcut key that may have been set-up
in a macro. I avoid using shortcut keys in my macros always, but somehow,
the copy paste shortcut must have become associated with one of them.

Thanks
Phil

Find Keyboard shortcut in a macro
 

Hi Phil,

To reset the Excel Shortcuts to their original functions, just start a new code module and run these lines of code:

------------------------------
Sub Reset()

Application.Onkey "^c", ""
Application.Onkey "^v", ""

End Sub
-----------------------------

Please let me know how you go.

SuperJas.

Find Keyboard shortcut in a macro
 

"AuthorizedUserPF" wrote in message ...
Good afternoon;
I have a slight problem with the Copy and Paste keyboard shortcut on my work
computer. It seems that after a couple of "cntrl copy" and "cntrl paste"
operations on a spreadsheet, Excel wants to paste an image of the
spreadsheet in the cell rather then the cell values or formula to be pasted.
I was told earlier that one of my macros may be using the "cntrl paste"
shortcut on the keyboard to perform another function. I have almost 200
macros.
Is there an easy way to identify the shortcut key that may have been set-up
in a macro. I avoid using shortcut keys in my macros always, but somehow,
the copy paste shortcut must have become associated with one of them.

Thanks
Phil


Hi Phil
Try this addin that will list the Short cut keys for Macros

http://www.xcelfiles.com/GetShortCutKeys.html

Find Keyboard shortcut in a macro
 

Thanks will do.
"SuperJas" wrote in message
...
Hi Phil,

To reset the Excel Shortcuts to their original functions, just start a new
code module and run these lines of code:

------------------------------
Sub Reset()

Application.Onkey "^c", ""
Application.Onkey "^v", ""

End Sub
-----------------------------

Please let me know how you go.

SuperJas.

Find Keyboard shortcut in a macro
 

Thanks this will definitely come in handy.

"Ivan F Moala" wrote in message
om...
"AuthorizedUserPF" wrote in message
...
Good afternoon;
I have a slight problem with the Copy and Paste keyboard shortcut on my
work
computer. It seems that after a couple of "cntrl copy" and "cntrl paste"
operations on a spreadsheet, Excel wants to paste an image of the
spreadsheet in the cell rather then the cell values or formula to be
pasted.
I was told earlier that one of my macros may be using the "cntrl paste"
shortcut on the keyboard to perform another function. I have almost 200
macros.
Is there an easy way to identify the shortcut key that may have been
set-up
in a macro. I avoid using shortcut keys in my macros always, but
somehow,
the copy paste shortcut must have become associated with one of them.

Thanks
Phil


Hi Phil
Try this addin that will list the Short cut keys for Macros

http://www.xcelfiles.com/GetShortCutKeys.html