+ Reply to Thread
Results 1 to 2 of 2

Delete Pivot table

  1. #1
    Registered User
    Join Date
    01-27-2006
    Posts
    15

    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..

  2. #2
    papou
    Guest

    Re: 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" <hurriance.29fmiz_1150355702.4559@excelforum-nospam.com> a écrit
    dans le message de news:
    hurriance.29fmiz_1150355702.4559@excelforum-nospam.com...
    >
    > 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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1