View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Coco Coco is offline
external usenet poster
 
Posts: 34
Default remove Worksheet using Sh.Delete without prompt

Can I remove a worksheet using a VBA function:
For example:

Sheet1.Delete

WITHOUT PROMPTING the user with this message:
"Data may exist in the sheet(s) selected for deletion. to permanently delete
the data, press Delete. "

Thanks

Coco
ps. I know that this Sheet1 has data. Moreover, it is not important in this
case.