Thread: using VBA how can I delete a worksheet w/o the warning message pop
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
  
Posts: 3,942
Default using VBA how can I delete a worksheet w/o the warning message pop
hi
Application.DisplayAlerts = False
Sheets("Sheet1").Select
ActiveWindow.SelectedSheets.Delete
application.DisplayAlerts = True


Regards
FSt1

"Jim K." wrote:

using VBA how can I delete a worksheet without having the warning message
popup "Data may exist in the sheet(s) ..."? I'm using
Sheets("Sheet1").Select
ActiveWindow.SelectedSheets.Delete
Reply With QuoteReply With Quote