LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Click event on menu item is lost after first time firing of the event [email protected] Excel Programming 1 April 2nd 07 01:25 PM
Change Event not firing L. Howard Kittle Excel Programming 3 December 16th 06 05:38 AM
Workbook_Open event not firing 0013 Excel Programming 4 May 24th 05 09:53 PM
Event sometimes stops firing? HotRod Excel Programming 7 May 5th 05 12:20 AM
OnTime event not firing in Workbook_Open event procedure GingerTommy Excel Programming 0 September 24th 03 03:18 PM


All times are GMT +1. The time now is 04:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"