PDA

View Full Version : [SOLVED] Deleting a sheet without a prompt



Dowsey1977
09-15-2005, 03:16 AM
Hi,

I'm using the below code as part of a macro to delete a sheet, however, the prompt to confirm sheet deletion appears. Is there anyway to avoid this and just delete the sheet??



Windows("Combined Form 6 Template macro2.xls").Activate
ActiveWindow.Close


Thanks,
Simon

Killian
09-15-2005, 03:28 AM
you can turn these messages off with


Application.DisplayAlerts = False

But don't forget to set this back to True when you're done

Dowsey1977
09-15-2005, 04:09 AM
That's great, thanks!