Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Avoid Confirmation Questions
How do I avoid this question:
Do you wish to replace the contents of the destination cells in Pivot Table? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to avoid delete confirmation | Excel Discussion (Misc queries) | |||
Confirmation box | Excel Programming | |||
Confirmation ID provided? | New Users to Excel | |||
Getting rid of confirmation boxes | New Users to Excel | |||
Confirmation of file | Excel Programming |