A negative to using Application.Onkey
 

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

A negative to using Application.Onkey
 

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)

"Andybro" wrote in message
...
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

A negative to using Application.Onkey
 

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

"Bob Phillips" wrote:

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)

"Andybro" wrote in message
...
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

A negative to using Application.Onkey
 

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)

"Andybro" wrote in message
...
Thanks Bob - I will give it a go (new to VBA so learning as I go along).

"Bob Phillips" wrote:

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)

"Andybro" wrote in message
...
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

A negative to using Application.Onkey
 

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" wrote:

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)

"Andybro" wrote in message
...
Thanks Bob - I will give it a go (new to VBA so learning as I go along).

"Bob Phillips" wrote:

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)

"Andybro" wrote in message
...
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

A negative to using Application.Onkey
 

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)

"Andybro" wrote in message
...
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" wrote:

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)

"Andybro" wrote in message
...
Thanks Bob - I will give it a go (new to VBA so learning as I go
along).

"Bob Phillips" wrote:

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)

"Andybro" wrote in message
...
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

A negative to using Application.Onkey
 

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

All done and working. Big Thanks.
Andy

"Bob Phillips" wrote:

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)

"Andybro" wrote in message
...
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" wrote:

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)

"Andybro" wrote in message
...
Thanks Bob - I will give it a go (new to VBA so learning as I go
along).

"Bob Phillips" wrote:

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)

"Andybro" wrote in message
...
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