How to undo macro task in excel

Asked Dec 24 '15 at 08:30

Active Dec 24 '15 at 08:30

Viewed 3,475 times

I am using excel 2010.

I have recorded following macro for playback (edited) and used customUI editor to make excel addin.

This is my first macro encounter with excel.

Sub Open1(control As IRibbonControl)
    With Selection.Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .Color = 65535
        .TintAndShade = 0
        .PatternTintAndShade = 0
    End With
    ActiveCell.FormulaR1C1 = "SomeText"
End Sub

Why the task is not being recorded for redo?

edited Jul 09 '18 at 18:41

Community

asked Dec 24 '15 at 08:30

Rahul

10,830
4
53
88

2

VBA actions are not stored by the application and therefore cannot be undone. One of the tough learning points for me was always, always save my base data before running VBA changes! – Ambie Dec 24 '15 at 08:36
Used to MS word which have memory to store changes even with VBAs. For excel Will keep in mind your advice – Rahul Dec 24 '15 at 08:38
1

There is an undo function for vba, but you must store in he previous data and code the undo action yourself – chris neilsen Dec 24 '15 at 08:44
I will search accordingly and try. – Rahul Dec 24 '15 at 08:48
@chrisneilsen Can you give little more hint as I am completely novice in excel VBA – Rahul Dec 24 '15 at 08:53
@Rahul [see this](http://stackoverflow.com/a/339263/445425) – chris neilsen Dec 24 '15 at 20:57

How to undo macro task in excel

0 Answers0