Excel 2007 - grayed undo/redo - Visual Basic Issue???

[Megan2682]

Hi There



In one of my worksheets, the undo function has stopped working, it has been suggested that the problem I am having is due to the VB applied to this worksheet:

Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
'Update 20140318
Static xRow
Static xColumn
If xColumn <> "" Then
    With Columns(xColumn).Interior
        .ColorIndex = xlNone
    End With
    With Rows(xRow).Interior
        .ColorIndex = xlNone
    End With
End If
pRow = Selection.Row
pColumn = Selection.Column
xRow = pRow
xColumn = pColumn
With Columns(pColumn).Interior
    .ColorIndex = 6
    .Pattern = xlSolid
End With

HOWEVER this VB has been applied to this worksheet for YEARS and it's only today that the undo has stopped worked?!!? Please note that the undo function works on all other worksheets.


Please Help

Thanks


Megan

 

[RedBeard]

There are lots of things that can reset the undo/redo stacks.

You could have run a macro (or an event macro could have fired).

You could have saved the workbook.

There's a setting in the windows registry that tells excel how many undo levels
to keep track of--maybe it was set to 0.

As you say you run a macro, there's the answer.