remove Worksheet using Sh.Delete without prompt
One way:
Application.DisplayAlerts = False
Sheet1.Delete
Application.DisplayAlerts = True
In article ,
"coco" wrote:
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.
|