i have just started using macros so dont know if this the normal or not... i made a mistake and went to undo that mistake and noticed that i couldnt undo as the function was greyed out.

before enabling the macro the function works.

is this normal and if so how do i use/create an undo function (using an extra macro or something)

im currently using a macro shown below. 

 Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    If Target.Count > 1 Then Exit Sub
    On Error Resume Next
    Application.ScreenUpdating = False
    Select Case Target.Column
    Case 5, 9, 13, 17, 21, 25, 29
        Target.Columns.ColumnWidth = 20
    Case Else
        Range("E:E").ColumnWidth = 1.43
        Range("I:I").ColumnWidth = 1.43
        Range("M:M").ColumnWidth = 1.43
        Range("Q:Q").ColumnWidth = 1.43
        Range("U:U").ColumnWidth = 1.43
        Range("Y:Y").ColumnWidth = 1.43
        Range("AC:AC").ColumnWidth = 1.43
        
    End Select
    Application.ScreenUpdating = True
End Sub
cheers in advance

wayne