SendKeys

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Wtadder,

Try:

Application.DisplayAlerts = False

' Your deletion code

Application.DisplayAlerts = True
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting a sheet during macro 1
Excel Move or Copy Stopped Working? 0
DREAM FEATURE: A macro that moves a row but asks me where to move it 18
Protecting macro code programatically 13
clear all sheets code 4
Delete Worksheets 4
Converting macros from Excel 2003 to Excel 2010 - Client Access dialog 3
Run macro from active workbook whose name keeps changing 20

Back
Top