Inactive UNDO REDo button due to a macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Priya - 25 Apr 2007 16:49 GMT

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

Reply to this Message

Dave Peterson - 25 Apr 2007 17:19 GMT

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

> 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
[quoted text clipped - 6 lines]
>
> Regards

Signature

Dave Peterson

Reply to this Message

JE McGimpsey - 25 Apr 2007 17:19 GMT

See

http://www.j-walk.com/ss/excel/tips/tip23.htm

> 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
[quoted text clipped - 6 lines]
>
> Regards

Reply to this Message

Rate this thread: