Logo 
Search:

MS Office Forum

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Answer a 'verify' popup

  Asked By: Klarissa    Date: Dec 23    Category: MS Office    Views: 679
  

I have written a macro that will delete a worksheet (or tab in the
workbook). When Excel hits that command a warning popup shows up that
has to have 'OK' or 'cancel' selected. Of course I want 'OK', but I
don't need the macro to stop when it gets there. How do I either
suppress that verification mesbox or automagically answer it without
the operator having to do something?

Share: 

 

6 Answers Found

 
Answer #1    Answered By: Roop Kapoor     Answered On: Dec 23

Check the VBA Help for DisplayAlerts. It will help you.

 
Answer #2    Answered By: Abasi Massri     Answered On: Dec 23

Surround your code with Display Alerts like following..

Application.DisplayAlerts = False
Worksheets("Sheet1").Delete
Application.DisplayAlerts = True

 
Answer #3    Answered By: Aylin Kaya     Answered On: Dec 23

I tried, and that does it!!!!!!!!!!!!!!!!!!

 
Answer #4    Answered By: Rhys Evans     Answered On: Dec 23

Post the code from your macro.

I delete  worksheets all the time without being asked to confirm.

 
Answer #5    Answered By: Mildred Bailey     Answered On: Dec 23

Now that is really interesting (to me, anyway. Do you get
the 'verification/cancel popup' when you manually delete  sheets?

 
Answer #6    Answered By: Lee Butler     Answered On: Dec 23

Yes, if I delete  the sheet from Excel, I get the confirmation pop-up.

If I delete sheets from VBA I don't get asked to confirm.

 
Didn't find what you were looking for? Find more on Answer a 'verify' popup Or get search suggestion and latest updates.




Tagged: