Inactive UNDO REDo button due to a macro

P

Priya

I have created a Pivot table and to dynamically calculate a calculated
field depending upon the selection in a page field I have written a
small piece of VBA code in Worksheet_Calculate event.
But this disables/deactivates Undo/Redo button at the top.

I have noticed that if I remove this macro I get this button back.

Can any body suggest how to get it back?

Regards
 
D

Dave Peterson

Lots of macros kill the Undo/Redo stack. My bet is that your macro is one of
them.
 
Top