Can you bypass excel generated pop ups.

  • Thread starter Thread starter Wandering Mage
  • Start date Start date
W

Wandering Mage

I am using a macro to delete sheets. I don't want excel
to ask if you are sure if you want to delete the sheets.
Is there anyway to make the prompt boxes stop popping up?
 
wandering, use this

Application.DisplayAlerts = False
'Your Code
Application.DisplayAlerts = True

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Awesome, great and quick help from all of you as usual!
Thank you.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DREAM FEATURE: A macro that moves a row but asks me where to move it 18
Create Pop-Up quiz Window with yes no questions 0
Macro to bypass pop-up box 2
Deleting sheets 3
Removing confirmation POP from excel 4
Excel Providing user message when RED X clicked & properly closing application. 2
Macro to generate powerpoint slides 43
Help with copying a sheet from One workbook to another workbook 1

Back
Top