A negative to using Application.Onkey

[Guest]

I have programmed an excel spreadsheet to activate a macro when the ENTER
button is pressed using the Application.Onkey command.

My problem is that if I then open another excel spreadsheet, and I press
ENTER, then the macro for the 1st speadsheet tries to run.

Is there a way to ensure that this macro runs only in the specific
speadsheet and not in every speadsheet I have open?

NB/ I have currently written the onkey command into Sheet1 of Microsoft
Excel Objects for the speadsheet.

Thanks

 

[Bob Phillips]

Set the key on the worbook activate event, and reset it on the workbook
deactivate event.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Thanks Bob - I will give it a go (new to VBA so learning as I go along).

 

[Bob Phillips]

Do you understand that Workbook activate and deactivate code MUST go in the
ThisWorkbook code module?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

No - I can accept this but I don't understand why. The activate and
deactivate events are available for each sheet, but I will follow your
instruction.
Thanks

 

[Bob Phillips]

They are, but we are talking about WORKBOOK activate,deactivate.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Bob, you need to change your name to "The Oracle".

All done and working. Big Thanks.
Andy