Question 1 of 3 - enabling/disabling confirmation request wh
Prep for a pre-employment Excel test with Job Test Prep
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

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
  •  

 

 
DMCA.com