Event not firing
 

In Excel 2000, I wrote a routine "Worksheet_Activate".
During the development of the routine, It worked fine. I saved the workbook
and exited.

When I execute the workbook and click on the tab for the worksheet, the
event no longer filres.

Does anybody have any ideas why and how I can correct it?

Thanks
--
Shell

Event not firing
 

Post the routine for checking.....

Are Application.EnableEvents enabled?


--

Regards,
Nigel




"Shell" wrote in message
...
In Excel 2000, I wrote a routine "Worksheet_Activate".
During the development of the routine, It worked fine. I saved the
workbook
and exited.

When I execute the workbook and click on the tab for the worksheet, the
event no longer filres.

Does anybody have any ideas why and how I can correct it?

Thanks
--
Shell

Event not firing
 

I don't know. Where would this code reside?
--
Shell


"Nigel" wrote:

Post the routine for checking.....

Are Application.EnableEvents enabled?


--

Regards,
Nigel




"Shell" wrote in message
...
In Excel 2000, I wrote a routine "Worksheet_Activate".
During the development of the routine, It worked fine. I saved the
workbook
and exited.

When I execute the workbook and click on the tab for the worksheet, the
event no longer filres.

Does anybody have any ideas why and how I can correct it?

Thanks
--
Shell

Event not firing
 

I have code in the worksheet_Activate event. The event is not firing.

When I right click on the worksheet tab and select View Code, I see the code
I want to execute.
--
Shell


"Nigel" wrote:

You say you wrote a routine, and that it is triggered by a
Worksheet_Activate event. Therefore there will be some code on the
worksheet in question.

Right click the worksheet tab and select View Code. This should be in the
following place

Private Sub Worksheet_Activate()
'Your code here <<
End Sub

If you do not have any code then what routine are you referring to?
--

Regards,
Nigel




"Shell" wrote in message
...
I don't know. Where would this code reside?
--
Shell


"Nigel" wrote:

Post the routine for checking.....

Are Application.EnableEvents enabled?


--

Regards,
Nigel




"Shell" wrote in message
...
In Excel 2000, I wrote a routine "Worksheet_Activate".
During the development of the routine, It worked fine. I saved the
workbook
and exited.

When I execute the workbook and click on the tab for the worksheet, the
event no longer filres.

Does anybody have any ideas why and how I can correct it?

Thanks
--
Shell

Event not firing
 

The specific code does not matter. I put a breakpoint on the first
executable statement in the Worksheet_Activate event. The code never gets
here.
--
Shell


"Nigel" wrote:

You asked where the code resides, now you know. It is this that needs to be
posted here.

Are Application.Events enabled?


--

Regards,
Nigel




"Shell" wrote in message
...
I have code in the worksheet_Activate event. The event is not firing.

When I right click on the worksheet tab and select View Code, I see the
code
I want to execute.
--
Shell


"Nigel" wrote:

You say you wrote a routine, and that it is triggered by a
Worksheet_Activate event. Therefore there will be some code on the
worksheet in question.

Right click the worksheet tab and select View Code. This should be in
the
following place

Private Sub Worksheet_Activate()
'Your code here <<
End Sub

If you do not have any code then what routine are you referring to?
--

Regards,
Nigel




"Shell" wrote in message
...
I don't know. Where would this code reside?
--
Shell


"Nigel" wrote:

Post the routine for checking.....

Are Application.EnableEvents enabled?


--

Regards,
Nigel




"Shell" wrote in message
...
In Excel 2000, I wrote a routine "Worksheet_Activate".
During the development of the routine, It worked fine. I saved the
workbook
and exited.

When I execute the workbook and click on the tab for the worksheet,
the
event no longer filres.

Does anybody have any ideas why and how I can correct it?

Thanks
--
Shell

Event not firing
 

I think we are going in circles!

I don't know if Application.events are enabled.
I don't know how to enable Application.events
--
Shell


"Nigel" wrote:

Are Application.Events enabled?

--

Regards,
Nigel




"Shell" wrote in message
...
The specific code does not matter. I put a breakpoint on the first
executable statement in the Worksheet_Activate event. The code never gets
here.
--
Shell


"Nigel" wrote:

You asked where the code resides, now you know. It is this that needs to
be
posted here.

Are Application.Events enabled?


--

Regards,
Nigel




"Shell" wrote in message
...
I have code in the worksheet_Activate event. The event is not firing.

When I right click on the worksheet tab and select View Code, I see the
code
I want to execute.
--
Shell


"Nigel" wrote:

You say you wrote a routine, and that it is triggered by a
Worksheet_Activate event. Therefore there will be some code on the
worksheet in question.

Right click the worksheet tab and select View Code. This should be in
the
following place

Private Sub Worksheet_Activate()
'Your code here <<
End Sub

If you do not have any code then what routine are you referring to?
--

Regards,
Nigel




"Shell" wrote in message
...
I don't know. Where would this code reside?
--
Shell


"Nigel" wrote:

Post the routine for checking.....

Are Application.EnableEvents enabled?


--

Regards,
Nigel




"Shell" wrote in message
...
In Excel 2000, I wrote a routine "Worksheet_Activate".
During the development of the routine, It worked fine. I saved
the
workbook
and exited.

When I execute the workbook and click on the tab for the
worksheet,
the
event no longer filres.

Does anybody have any ideas why and how I can correct it?

Thanks
--
Shell

Event not firing
 

Did you allow your macros to run (that security prompt) when you opened the
workbook?

Are you in design mode?
View|toolbars|control toolbox toolbar
You'll see an icon that has a tooltip of "design mode". Is that icon depressed?

And if you do have events turned off, you can do this:

hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter
application.enableevents = true

Then back to excel. Go to a different sheet and select the sheet you want.

Remember that this event fires when you change to this sheet. So maybe you're
opening this workbook with this sheet selected and that's why you don't see the
event fire????

Shell wrote:

In Excel 2000, I wrote a routine "Worksheet_Activate".
During the development of the routine, It worked fine. I saved the workbook
and exited.

When I execute the workbook and click on the tab for the worksheet, the
event no longer filres.

Does anybody have any ideas why and how I can correct it?

Thanks
--
Shell

--

Dave Peterson