Hello Everyone,
At the moment I am using Excel 2000 and I was wondering if there was a way to assign existing tools such as Cut, Copy, Paste, Etc. to the "Function" keys F1-F12 on a global level (available in all spreadsheets)
Not sure exactly what my hotkey layout will be at the moment, but lets say for this post that I want....
The following to be assigned to the existing tools CUT, COPY and PASTE (not Macros, so they can be undone)
F3 - "Copy"
F4 - "Cut"
F5 - "Paste"
In doing some research I found many examples that look like the code below.
Which I have gotten to work fine, the problem is I just don't know the value to enter for the existing tools CUT, COPY, PASTE.
I could create a single macro for each and just apply the macro this way below, but in using the existing tools I will be able to use the "undo" command and with a macro I probably wouldn't be able to do so.
Can something like this be done?
Thank You to anyone who reads this and for any advice.
At the moment I am using Excel 2000 and I was wondering if there was a way to assign existing tools such as Cut, Copy, Paste, Etc. to the "Function" keys F1-F12 on a global level (available in all spreadsheets)
Not sure exactly what my hotkey layout will be at the moment, but lets say for this post that I want....
The following to be assigned to the existing tools CUT, COPY and PASTE (not Macros, so they can be undone)
F3 - "Copy"
F4 - "Cut"
F5 - "Paste"
In doing some research I found many examples that look like the code below.
Which I have gotten to work fine, the problem is I just don't know the value to enter for the existing tools CUT, COPY, PASTE.
I could create a single macro for each and just apply the macro this way below, but in using the existing tools I will be able to use the "undo" command and with a macro I probably wouldn't be able to do so.
Can something like this be done?
Thank You to anyone who reads this and for any advice.
Code:
Private Sub Workbook_Open()
Application.OnKey "{F9}", "MyMacro"
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnKey "{F9}", ""
End Sub