View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tijmen Tijmen is offline
external usenet poster
 
Posts: 3
Default prevent warning message from appearing

I want to remove a sheet

Sheets(2).Delete

Excel then comes up with a warning: "The selected sheet(s) will be
permananently deleted. To delete the selected sheets, click OK.To cancel the
deletion, click Cancel"

Can I somehow catch this message end prevent it from appearing?

Thanks,

Tijmen