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
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