ignoring messageboxes when deleting tabs?

    in my macro it deletes certain sheets, but hangs since excel will pop up a box asking if you want to continue or cancel the sheet deletion. anyway to get around it?

    Re: ignoring messageboxes when deleting tabs?


    Before your code that deletes: Application.DisplayAlerts = False


    After your code that deletes: Application.DisplayAlerts = True


    Regards,

    Barrie Davidson
    My Excel Web Page
    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login