Event not firing

[Shell]

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

 

[Nigel]

Post the routine for checking.....

Are Application.EnableEvents enabled?

 

[Shell]

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

 

[Shell]

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]

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]

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

 

[Dave Peterson]

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????