Can you bypass excel generated pop ups.
 

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?

Can you bypass excel generated pop ups.
 

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 **
"Wandering Mage" wrote in message
...
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?

Can you bypass excel generated pop ups.
 

Awesome, great and quick help from all of you as usual!
Thank you.
-----Original Message-----
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 **
"Wandering Mage"
wrote in message
...
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?


.