Macro to AutoAnswer
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
tc wrote:
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?
|