Application.onkey error 1004 (even with very simple code)

**MJrush** · 09-29-2021, 04:30 PM

Hello all! This is my first post, I just registered, hopefully I won't break any forum rules.

I am trying to make application.Onkey work on my excel. I keep getting error 1004 message. I decided to try at least to make it work in a new .xlsm file with nothing in it, except this code... and I still get the error message. I really don't know what is wrong. Please help.

Private Sub Workbook_Open()
Application.OnKey "^{+}{P}", "test"
End Sub

Sub test()
ThisWorkbook.Sheets(1).Range("a1").Select
End Sub

**TMS** · 09-29-2021, 04:52 PM

You might need to Select Sheets(1) before you can select a cell on it.

Depends which sheet is Active when the workbook opens.

**MJrush** · 09-29-2021, 05:02 PM

Hello, thanks for the answer. I tried to add a select and I still get the same error message.

**TMS** · 09-29-2021, 05:30 PM

Examples:

Option Explicit

Sub test()
' action
Debug.Print "test"
ThisWorkbook.Sheets(1).Range("a1").Select
End Sub

Sub test2()
' switch *on*
' Ctrl-Shift-P
Debug.Print "test2"
Application.OnKey "^{P}", "test"
End Sub

Sub test3()
' switch *off*
' Ctrl-Shift-P
Debug.Print "test3"
Application.OnKey "^{P}", ""
End Sub

These are all in a standard module for testing.

Application.onkey error 1004 (even with very simple code)

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Application.onkey error 1004 (even with very simple code)

Re: Application.onkey error 1004 (even with very simple code)

Re: Application.onkey error 1004 (even with very simple code)

Re: Application.onkey error 1004 (even with very simple code)

Thread Information

Users Browsing this Thread

Similar Threads

VBA - Getting application error code 1004 when trying to fetch defects from QC 10

HELP WITH ERROR CODE '1004' Application-defined or object defined error

[SOLVED] Error 1004 (application-defined) in my VBA code

[SOLVED] Getting Error 1004 Object or Application Defined Error - Code to rearrange data

Error When Implementing Code: "1004 - Application-defined or object-defined error"

Application Error 1004 running Pivot Code

[SOLVED] Application-Defined or Object-Defined Error on simple code

Bookmarks

Bookmarks

Posting Permissions