Warning message for deleting sheet turned off

[takformaten]

Hi guys,

my sheet -with the loads of help I retrieve from you guys- starts looking flashy and nice, and I am not too far away.

Now, a macro I wrote deletes a worksheet, which is good, cause this is what it is meant to do. Yet this warning message "Data might exist in the sheet..." keeps popping up. Can I turn that off somewhere? Or make my Macro click OK? Or any other brilliant idea?

Cheers for your help!

TAK

 

[Tom Urtis]

Sandwich your sheet deletion code line in between alerts manipulation, like so:


Application.DisplayAlerts = False

'your sheet deletion code goes here

Application.DisplayAlerts = True

 

[takformaten]

WOW !!!

Probably a small step for men, who know excel, but an enormous step for my little workbook!

ray: