Excel 2007 : undo/redo function missing after enabling macro

**wayneg** · 06-20-2012, 10:58 AM

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

**wayneg** · 06-20-2012, 02:27 PM

does anybody know???

**shg** · 06-20-2012, 03:01 PM

When a macro changes the environment (e.g., a cell, a style, a column width, almost anything), the Undo stack is flushed. It's a good reason to think twice before adding macros to a workbook.