is there a way to assign copy and paste to a function key or some other key
combination?

i tired this and it didn't work, it still bring up the help pane.

Application.OnKey "^{F1}", "^{C}"

--


Gary

The second argument in Application.OnKey is the name of the macro you
want to run when the user presses the key in the first argument...

It doesn't allow you directly map one key onto another.


In article ,
"Gary Keramidas" <GKeramidasATmsn.com wrote:

is there a way to assign copy and paste to a function key or some other key
combination?

i tired this and it didn't work, it still bring up the help pane.

Application.OnKey "^{F1}", "^{C}"

Is there a method in VBA that allows each macro to be scanned to determine if
it has an OnKey assignment?
--
Gary''s Student - gsnu200755


"JE McGimpsey" wrote:

The second argument in Application.OnKey is the name of the macro you
want to run when the user presses the key in the first argument...

It doesn't allow you directly map one key onto another.


In article ,
"Gary Keramidas" <GKeramidasATmsn.com wrote:

is there a way to assign copy and paste to a function key or some other key
combination?

i tired this and it didn't work, it still bring up the help pane.

Application.OnKey "^{F1}", "^{C}"

Not AFAIK.

In article ,
Gary''s Student wrote:

Is there a method in VBA that allows each macro to be scanned to determine if
it has an OnKey assignment?

Getting Macro Short cut keys, by Ivan F Moala
"If you've ever wanted to get the short cut keys for your macros listed then here is an Addin that will help you get these."
http://www.xcelfiles.com/GetShortCutKeys.html

You might also be interested in
Shortcuts Found in Excel Menus
http://www.mvps.org/dmcritchie/excel/shortmenu.htm

Links to both of the above can be found on my page on shortcuts:
Shortcut Keys in Excel 2000 through Excel 2007
http://www.mvps.org/dmcritchie/excel/shortx2k.htm
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"JE McGimpsey" wrote in message ...
Not AFAIK.

In article ,
Gary''s Student wrote:

Is there a method in VBA that allows each macro to be scanned to determine if
it has an OnKey assignment?

thanks, wasn't sure about that.

--


Gary


"JE McGimpsey" wrote in message
...
The second argument in Application.OnKey is the name of the macro you
want to run when the user presses the key in the first argument...

It doesn't allow you directly map one key onto another.


In article ,
"Gary Keramidas" <GKeramidasATmsn.com wrote:

is there a way to assign copy and paste to a function key or some other key
combination?

i tired this and it didn't work, it still bring up the help pane.

Application.OnKey "^{F1}", "^{C}"

hi
this has been built in since before windows.... before the mouse.
ctrl + x = cut
crtl + c = copy
crtl + V = Paste
see this site for more keyboard shortcuts....
http://www.cpearson.com/excel/KeyboardShortcuts.htm

Regards
FSt1

"Gary Keramidas" wrote:

is there a way to assign copy and paste to a function key or some other key
combination?

i tired this and it didn't work, it still bring up the help pane.

Application.OnKey "^{F1}", "^{C}"

--


Gary

i know that. i had a type. i don't want to use control f1, i just want to use f1

Application.OnKey "{F1}", "^{C}"

--


Gary


"FSt1" wrote in message
...
hi
this has been built in since before windows.... before the mouse.
ctrl + x = cut
crtl + c = copy
crtl + V = Paste
see this site for more keyboard shortcuts....
http://www.cpearson.com/excel/KeyboardShortcuts.htm

Regards
FSt1

"Gary Keramidas" wrote:

is there a way to assign copy and paste to a function key or some other key
combination?

i tired this and it didn't work, it still bring up the help pane.

Application.OnKey "^{F1}", "^{C}"

--


Gary