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.

Please Login or Register  to view this content.

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.