Prevent PivotTable Overwrite Warning and Disallow Overwrite



Hello -

I'm using Excel 2007 and am changing the contents of a PivotTable with
VBA. I would like to programmatically suppress the warning message
produced when a PivotTable changes size and would overwrite non-empty
cells below or to the right of the table and disallow the overwriting.
The message asks, "Do you want to replace the contents of the
destination cells in <<Worksheet Name>>?"

Using Application.DisplayAlerts = FALSE prevents the warning message,
but it allows the overwriting. What can I use, perhaps in addition, to
disallow the overwriting?


- Jonah


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