Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |