MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

excel 2000 - Delete confirmation

  Asked By: Kristopher    Date: Feb 13    Category: MS Office    Views: 721

I'm deleting some worksheets in VBA. Can anyone please tell me how to
turn off the "do you realy want to do this" message please?



1 Answer Found

Answer #1    Answered By: Madiha Malik     Answered On: Feb 13

Just add Application.DisplayAlerts = False to your code. Just make sure
you add Application.DisplayAlerts = True to the end of your code or you
won't get warnings for anything at all the rest of the time you're working
in Excel.

Didn't find what you were looking for? Find more on excel 2000 - Delete confirmation Or get search suggestion and latest updates.