Most macro code clears the undo history as a by product of running.

It appears your code fits into this category.

--
Regards,
Tom Ogilvy


"Shailesh" wrote:

I have created a Pivot table having one Macro in the
Worksheet_calculate sub.In this macro I dynamically change the
formula of a calculated field depending upon the selection made in one
of the page fields.

How ever I am having a strange problem in this pivot. Here UNDO and
REDO buttons are disabled/

Can any one please suggest me how to correct this?