Avoid Confirmation Questions
 

How do I avoid this question:

Do you wish to replace the contents of the destination cells in Pivot Table?

Avoid Confirmation Questions
 

Application.DisplayAlerts=false
The above statement will stop the response, but if a user just clicks in the
pivot table currentpage changing cell, I can't capture to change change the
above to false before the change is made. Then I get the question below.
VBA Help says the property changes back to true when code stops, so I can't
make it false before code starts and can't capture the clicking of the
currentpage cell. Ideas?


"Mike H." wrote:

How do I avoid this question:

Do you wish to replace the contents of the destination cells in Pivot Table?