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

Dynamic Naming of Form Button 3
undo - redo button 8
UNDO and REDO buttons are inactive 7
To enable Redo edit button from vc++ 0
Excel automatically does undo on my worksheet 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Why Undo and Redo button are disabled in my Pivot 0
Undo and redo in word 1

Top