PC Review


Reply
Thread Tools Rate Thread

Prevent PivotTable Overwrite Warning and Disallow Overwrite

 
 
jonahviakeyboard
Guest
Posts: n/a
 
      27th Nov 2007
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?

Thanks.

- Jonah
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get the PivotTable report info that feeds another PivotTable report. Toby Erkson Microsoft Excel Discussion 2 29th Dec 2004 04:03 PM
How does one get the PivotTable report info that feeds another PivotTable report? Toby Erkson Microsoft Excel Programming 0 14th Dec 2004 11:00 PM
FP03 publish to overwrite or not to overwrite =?Utf-8?B?RGVsdGFHYW1tYQ==?= Microsoft Frontpage 3 27th Oct 2004 01:43 AM
PivotTable - PivotTable Field name is not valid - error! miker1999 Microsoft Excel Programming 1 10th Jun 2004 10:30 AM
Creating a PivotTable Report from an Another PivotTable Report =?Utf-8?B?YmNwYXVsdXM=?= Microsoft Excel Programming 1 8th Jan 2004 08:56 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:42 PM.