View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Shell Shell is offline
external usenet poster
 
Posts: 32
Default 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