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..
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..
Hello
Place this line before deleting your pivot table:
Application.DisplayAlerts = False
And place this after:
Application.DisplayAlerts = True
HTH
Cordially
Pascal
"hurriance" <[email protected]> a écrit
dans le message de news:
[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks