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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to delete a worksheet without getting a deletion warning? 2

Status
Not open for further replies.

JensKKK

Technical User
May 8, 2007
119
GB
I want to delete a worksheet using the

sheets("sheet1").delete command

but I don't want to get the deletion warning on the screen.

Any ideas on hwo to bypass the deletion warning???
 
Application.DisplayAlerts = False

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 

I'm pretty sure it's this one:-

Code:
Application.DisplayAlerts = False

J.
 
don't forget to set them back to TRUE afterwards though...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Brillaint thanks for your speedy replies.

The command works for me.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top