Results 1 to 3 of 3

Thread: Disable Excel warning/message boxes

  1. #1

    Thread Starter
    Member
    Join Date
    Aug 2005
    Location
    West Midlands, UK
    Posts
    33

    Arrow Disable Excel warning/message boxes

    I am deleting worksheets in vba by using the line:

    worksheet("Sheet2").delete

    However Excel displays a warning box that it is about to delete a sheet. At which point user can presss cancel, which is not something I want user to do.

    Is there any way to stop Excel from displaying the message box.

    Thank you for your help.

  2. #2
    Frenzied Member
    Join Date
    May 2004
    Location
    Carlisle, PA
    Posts
    1,045

    Re: Disable Excel warning/message boxes

    Application.DisplayAlerts = False

    Application.DisplayAlerts = True
    Blessings in abundance,
    All the Best,
    & ENJOY!

    Art . . . . Carlisle, PA . . USA

  3. #3

    Thread Starter
    Member
    Join Date
    Aug 2005
    Location
    West Midlands, UK
    Posts
    33

    Resolved <Resolved> Disable Excel warning/message boxes

    So easy when you know, also the easy is the first missed.

    Thank you for your fast help.

Posting Permissions

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



Click Here to Expand Forum to Full Width