View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Pierre Archambault Pierre Archambault is offline
external usenet poster
 
Posts: 35
Default Disabling Excel VBA Pop-ups...

Application.DisplayAlerts = False

Pierre


"Joey Lichtenstein" a écrit dans le message de
...
I have done this before, but I can't find ANYWHERE in the VBA help how I
did this.

What is the command in Excel VBA to make it not care when I want to delete
worksheets in a workbook in my code? For example, inside my code I am
trying to automate a:
ActiveWindow.SelectedSheets.Delete
And I don't want to have to deal with the OK/Cancel Window:
The selected sheet(s) will be permanantly deleted.

Thanks so much!

Joey