SendKeys
 

I am running a macro to Load data into a Data sheet and once it's in the
excel I want to delete the data sheet. When you delete a sheet message box
always comes up and makes sure its ok to delete. How can I delet these
sheets without having the macro stop to ask if its ok to delete the sheet.
Is there a special Sendkey function that will stop this message box from
coming up?

Thanks,

Will

SendKeys
 

Hi Wtadder,

Try:

Application.DisplayAlerts = False

' Your deletion code

Application.DisplayAlerts = True


---
Regards,
Norman



" wrote in
message ...
I am running a macro to Load data into a Data sheet and once it's in the
excel I want to delete the data sheet. When you delete a sheet message
box
always comes up and makes sure its ok to delete. How can I delet these
sheets without having the macro stop to ask if its ok to delete the sheet.
Is there a special Sendkey function that will stop this message box from
coming up?

Thanks,

Will