View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Wilson John Wilson is offline
external usenet poster
 
Posts: 550
Default help: automated delete without question

FireatHome,

Just prior to that line of code:
Application.DisplayAlerts = False
and just after it
Application.DisplayAlerts = True

John

FireatHome wrote:

In VBA I delete a sheet with this command:
"ActiveWindow.SelectedSheets.Delete"

I get a msgbox where I have to "OK" to perform the delete.

Q: How to delete without the msgbox