Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing F keyes
I used to have a keyboard with CUT, COPY & PASTE as single keystrokes. Now I have a new keyboard without them, and I miss them. I want to make 3 adjoining keyes (say F10, F11, F12) into SINGLE STROKE SHORTCUTS. I have achieved it with Corel & Word but can't do it with Exel. -- Thanks for any help....David Roper |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing F keyes
I wouldn't do this. I think you'll find that excel behaves better if you use
the built in shortcut keys--ctrl-x to cut, ctrl-c to copy and ctrl-v to paste. Running macros can have effects that you don't want--one of these problems is that the Undo and Redo stack is sometimes (usually!) killed. But if you want, ... You can use a macro to reassign your F keys: Option Explicit Sub ReassignF10() Application.OnKey "{f10}", "'" & ThisWorkbook.Name & "'!NewF10" Application.OnKey "{f11}", "'" & ThisWorkbook.Name & "'!NewF11" Application.OnKey "{f12}", "'" & ThisWorkbook.Name & "'!NewF12" End Sub Sub BackToNormal() Application.OnKey "{f10}" Application.OnKey "{f11}" Application.OnKey "{f12}" End Sub Sub NewF10() On Error Resume Next Selection.Cut If Err.Number < 0 Then Beep End If On Error GoTo 0 End Sub Sub NewF11() On Error Resume Next Selection.Copy If Err.Number < 0 Then Beep End If On Error GoTo 0 End Sub Sub NewF12() On Error Resume Next ActiveSheet.Paste If Err.Number < 0 Then Beep End If On Error GoTo 0 End Sub droper wrote: I used to have a keyboard with CUT, COPY & PASTE as single keystrokes. Now I have a new keyboard without them, and I miss them. I want to make 3 adjoining keyes (say F10, F11, F12) into SINGLE STROKE SHORTCUTS. I have achieved it with Corel & Word but can't do it with Exel. -- Thanks for any help....David Roper -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Max | Excel Worksheet Functions | |||
changing a cell to changing the link | Excel Worksheet Functions | |||
NOW() keeps changing | Excel Discussion (Misc queries) | |||
Changing format of number without changing the value | Excel Discussion (Misc queries) | |||
changing #value! to 0's | Excel Worksheet Functions |