Find Keyboard shortcut in a macro

[AuthorizedUserPF]

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

 

[Guest]

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

 

[Ivan F Moala]

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

 

[AuthorizedUserPF]

Thanks will do.

Hi Phil,

To reset the Excel Shortcuts to their original functions, just start a new

code module and run these lines of code:

 

[AuthorizedUserPF]

Thanks this will definitely come in handy.

"AuthorizedUserPF" <[email protected]> wrote in message


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

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