Event Macros Not Being Triggered

[Emma Farrell]

Good Afternoon,

In my workbook I have a series of workbook_change events that, until the other day worked beautifully!!

Now, the don't seem to be triggered when they should be.

I have looked through all my code and removed all instances of Application.EnableEvents = False that could possible be the cause

AND have checked (through debug.print) that events are indeed enabled

Yet they still do not seem to be working and I am at a loss as to why

Any one got any suggestions?????

Cheers
Emma

 

[Andrew Poulsom]

Are macros enabled?

 

[Trebor76]

Hi Emma,

Does seem strange. Has the macro security changed so that no macros are working?

If not, what event is the trigger?

Robert

 

[Emma Farrell]

yep - I also have quite a few that run on a button click - they are all working fine!

 

[Emma Farrell]

I have set the macro security to low thinking that it might have been the cause ... no luck

Working:-
SomeButton_Click

Not Working:-
Workbook_SheetDeactivate
Workbook_SheetActivate
Workbook_Open - this was actually working this morning
Worksheet_Change

 

[Trebor76]

Is it a Worksheet_Calculate event macro but the calculation method has been switched to manual ?

 

[Emma Farrell]

Hmmm ... I've never used a Worksheet_Calculate event before but have set calculation to manual (and back again) in a few routines.

I'll check it out and let you know

 

[Emma Farrell]

Calculation mode is set to automatic ...

I use this routine to reset if I crash it while 'playing'

Sub BreakErr()
    Application.Calculation = xlCalculationAutomatic
    Application.EnableEvents = True
    Application.ScreenUpdating = True
    On Error GoTo 0
End Sub

 

[Trebor76]

Not sure then I'm afraid

It may be a memory issue if it's a large workbook i.e. plenty of tabs with many used cells - especially if it's Excel 2007