How do I? 1

[Tuff]

Ok got a bit of tricky on here.
I have written a macro in excel, and it creates a sheet alters the data in it, and then delete the sheet.

However when I run the macro it always comes up with the message box asking.

The Selected sheet will be permantely deleted.
To Delete the selected sheets, click OK.
To Cancel the Deletion, click Cancel.
With the OK and Cancel boxes below.


Is there any way I can get the Macro to click ok so I don't have to see it everytime?

 

[xlbo]

Application.displayalerts = false
at the start of the macro and
Application.displayalerts = true
at the end
And a bit more of a meaningful subject title next time please


Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde