Bruce,
Just prior to that line of code to delete the sheet:
Application.DisplayAlerts = False
and right after it
Application.DisplayAlerts = True
John
Bruce B wrote:
I have a line of code (excel 2000) that deletes a sheet. When it runs a
system message pops up and asks if I really want to delete the sheet.
Is there any way that I can turn this system message off?
Thanks!
- Bruce
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!