View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hamishd hamishd is offline
external usenet poster
 
Posts: 2
Default Deleting a sheet with VBA

Hi, i'm using the line:
Sheets("Sheet2").Delete

However, on execution, I get a warning messagebox:
"Data may exist in the sheet(s) selected for deletion. To permanently
delete the data, press Delete."

How do I suppress messages of these types?

Thanks.