Workbook_SheetChange not working in Excel 2010

Hi,

I created .xlsm in Excel 2016 (Professional Plus) on Win 10. It works fine in Excel 2016, but file is intented for use in Excel 2010 (also Pro Plus).
File was created from my available .lib references, which is Microsoft Excel 16.0 library.

When I ran file in Excel 2010 on Win 7, I had to eliminate missing .lib reference of Microsoft Excel 16.0 library for avoiding VBA error "Can't find project or library",
because available reference in Excel 2010 is only Microsoft Excel 14.0 library.
Solution for this is suggested here:https://support.microsoft.com/en-us/...e-when-you-run

So file opens now without any VBA error and everything works fine except Workbook_SheetChange code, which is not even being fired:

Please Login or Register  to view this content.

Code doesn't look too complicated to me, so I'm out ideas on what could be wrong. So If you have any suggestions - thanks in advance !

Hi Richard,

thanks for pointing me out, I fixed problem.

Explanation - I have also Workbook_Open event :

Please Login or Register  to view this content.

So, in Workbook_Open I set track_changes to True, then lock 1st sheet. This works in Excel 2016 and Win10, but not in Excel 2010. I had to move track_changes=True inside If statement, after locking sheet, and now code works. It's still weird thing for me though.