Ctrl Z not working with VBA Column Auto Fit code

[Peter Davison]

I currently have the following code in a worksheet, however when it is on Ctrl Z will not work, but when the code is not on it will.
Any thoughts why this is happening?
And if there is a resolve?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.EntireColumn.AutoFit
End Sub


Thanks

 

[Peter Davison]

I assigned it to a button