Avoid Confirmation Questions

  • Thread starter Thread starter Mike H.
  • Start date Start date
M

Mike H.

How do I avoid this question:

Do you wish to replace the contents of the destination cells in Pivot Table?
 
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?
 
You must log in or register to reply here.

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

Altered pasting functionality 3
Adaptable pivot table ranges 3
avoid message that asks for confirm delete sheet 1
How to add straight line from cell value in pivot table chart 1
Avoid Update Values Prompts 6
Corrupt files due to pivot remnants after saving via VBA 0
Replace Contents of Destination Cells 2
Wanted to show 12 month Date in Pivot table 2

Back
Top