Embedded code to auto re-size columns no longer working in win10/excel2016

[paquirl]

I had this embedded code in a worksheet to auto re-size columns. When I upgraded to win10/excel2016 it no longer works. Please help!

Option Explicit

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    Application.ScreenUpdating = False
    ActiveSheet.Columns.AutoFit
End Sub

 

[Fluff]

If you run this

Sub chk()
Application.EnableEvents = True
End Sub

does your code work again?

 

[paquirl]

actually it works now on some columns ...
i'll try yours

 

[paquirl]

Apparently my old code still works, but it's slowwwwww.
Also, excel2016 is disabling my macros and i have to hit a button to enable them on each wkbk. Do you know where the setting to toggle this feature is located so the macros are enabled by default?

 

[Fluff]

Its in File > Options >Trust center > Trust center settings

 

[paquirl]

Thank you!

 

[Fluff]

You're welcome