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