Delete Pivot table
 

I have writen a macro, one part of it is to create a pivot table and
then delete it. However, before the pivot table is deleted, a box is
pop up
to ask me whether delete it or not, I want to disable this box.
How can it achieve it ? thxx..


--
hurriance
------------------------------------------------------------------------
hurriance's Profile: http://www.excelforum.com/member.php...o&userid=30882
View this thread: http://www.excelforum.com/showthread...hreadid=552141

Delete Pivot table
 

Hello
Place this line before deleting your pivot table:
Application.DisplayAlerts = False
And place this after:
Application.DisplayAlerts = True

HTH
Cordially
Pascal

"hurriance" a écrit
dans le message de news:
...

I have writen a macro, one part of it is to create a pivot table and
then delete it. However, before the pivot table is deleted, a box is
pop up
to ask me whether delete it or not, I want to disable this box.
How can it achieve it ? thxx..


--
hurriance
------------------------------------------------------------------------
hurriance's Profile:
http://www.excelforum.com/member.php...o&userid=30882
View this thread: http://www.excelforum.com/showthread...hreadid=552141