Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel VBA, delete sheet without confirming

Status
Not open for further replies.

daveask

Programmer
Joined
Aug 11, 2004
Messages
108
Location
GB
Hi,

In Excel VBA, how to delete a sheet without poping up the confirm window?

Thank you in advance.
 
daveask,
We have a dedicated vba forum where the question belongs:
In the meantime, you can try set
[tt]application.displayalerts=false[/tt]
then switch back to true after the operation (for safety).
regards - tsuji
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top