Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Click event on menu item is lost after first time firing of the event | Excel Programming | |||
Change Event not firing | Excel Programming | |||
Workbook_Open event not firing | Excel Programming | |||
Event sometimes stops firing? | Excel Programming | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming |