View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Colin Hayes Colin Hayes is offline
external usenet poster
 
Posts: 465
Default VBA to sidestep popups...

In article , Rick Rothstein
writes
Try it this way...

Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True



Hi All

OK Thanks for the suggestions - that's fixed it. No more popup.

Thanks.