Macro to AutoAnswer

  • Thread starter Thread starter tc
  • Start date Start date
T

tc

Hi. The macro i have made deletes a particular sheet after
calculations have been made. however Excel gives me a warning that the
sheet might contain data, are you sure you want to delete it. Is it
possible to create a macro to automatically answer this question?
 
Hello
Include this into your macro before the sheet deletion:
Application.DisplayAlerts = False
'... your code here

'And remember to set it back to :
Application.DisplayAlerts = True
'when you're finished

HTH
Cordially
Pascal
 
You can simply make the warning not display at all. Just have to be
certain that you cut the displays back on.
Sub foo()
Application.DisplayAlerts = False
Sheets(1).Delete
Application.DisplayAlerts = True
End Sub
 

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

Macro to Combine Data from Multiple Sheets with Cell References 4
Macro to bypass pop-up box 2
Trying to recover deleted macros 0
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Macro for all Excel Workbooks to print to PDF 2
Deleting Sheets via Macro 6
Error Message - Macro to Unlink MS Queries from Workbook 0
Run macro from active workbook whose name keeps changing 20

Back
Top