Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Question 1 of 3 - enabling/disabling confirmation request wh

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    (I have searched the archive before posting, so forgive me if these questions have been answered before)

    Is it possible to disable the "OK/Cancel" confirmation request that comes up when you try to delete a worksheet, and if so how?

    Thanks,
    wbrien

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Use this:

    Application.DisplayAlerts=False
    Sheet1.Delete
    Application.DisplayAlerts=True


  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    DMeador52 - sorry for taking so long to say thank you

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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