Use enter key to start macro

[GoodmanJim]

I would like to start a macro when the person depresses the enter in a worksheet and not on the other worksheets in a workbook.

Thank you for your help in advance
Jim

 

[Gary McMaster]

Code for the indicated event of the target worksheet.

Hope it helps.

Gary

Private Sub Worksheet_Activate()

'Run "MyMacro" when Enter (Return) key is pressed
Application.OnKey "{RETURN}", "MyMacro" ' Change name to suit

End Sub

Private Sub Worksheet_Deactivate()

'Restore Enter (Return) key to normal function
Application.OnKey "{ENTER}", ""

End Sub

 

[shg]

Gary,

I think the last line should be

Application.OnKey "{RETURN}"

As it is, I think you're disabling the Enter key on the numeric keypad.

 

[Gary McMaster]

Yes. Thanks for the heads up.

I tried them both and failed to make the correction after I decided which one it should be.

My edit time has probably already expired.

Gary

 

[GoodmanJim]

Thanks to both of you

It works like a charm

Jim