VBA On Worksheet Calculate not working

Good Day,

I have a snippet of VBA code that resides in my worksheet under the "On Worksheet Calculate" trigger. Basically, the code is supposed to run whenever the worksheet calculates anything.

Yesterday it was working fine, now when I open the file this morning, the macro isn't running at all.

If I manually run the macro from within the VB window, it runs correctly, but it doesn't run when the worksheet recalculates like it supposed to.

If anyone could provide any insight into this issue, it would be greatly appreciated.

Regards,
Chris

I tried that, and events are enabled.

Perhaps its something in my methodology. I am trying to trigger a macro that executes when a "group" is opened or closed. I was told that whenever a group is opened or closed, it forces a worksheet calculation, and I can write code that executes on worksheet calculation. I did that, and it worked perfectly yesterday. Now opening or closing the group doesn't seem to be triggering a worksheet calculation.

Okay, I've attached a sample

In this workbook, Cell H1 has text in it that should change from white to black when the grouping is closed, and back to white when the grouping is opened.

This worked perfectly for me yesterday, but it isn't working now.

Thanks,
Chris

I did, and I do on my actual sheet now as well. The only thing that changed since it was working yesterday is that I saved the sheet, closed it, and reopened it today.

Yes, automatic calculation is turned on. Following your logic, I added an = now() calculation to my sheet, and now it works. That doesn't make sense to me though, as there is an entire row of sum calculations that should also trigger the event.

I suppose for now I will just hide the =now() somewhere on the sheet and try to pinpoint the root of the problem later.

Thanks for the help.