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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UNDO and REDO buttons are inactive 7
"Undo" and "Redo" are suddenly grayed out 2
A discussion about the Undo-stack in Excel 0
Excel should undo/redo after saving a file--just like Word. 3
How to undo then redo the current formats in a macro 2
Problem Assigning Macro to Button 3
Excel Excel vba: "How to make a selection box and assigned it to macro-button" 3
How to start a macro with pivot-chart-update-button (!) 4

Top