Hi,
I have just migrated a huge Excel project from 32 bit to 64 bit, Excel 2010 to Excel 365.
It has been surprisingly easy – all I had to do was to update the Declare statements.
Or so I thought.
There is just one bug left.
Worksheet code does not seem to run at all.
The code (now with a MsgBox for test purposes) starts like this . . .
Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox “there has been a change”
And so on. But the absence of a message just confirms what I thought – the code is not running at all.
Any ideas what is happening, please ?
