View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mikey Mikey is offline
external usenet poster
 
Posts: 38
Default Code to OK DeleteSheet automatically

Works perfectly. Thanks for the time.
--
Mickey


"Tom Hutchins" wrote:

Put Application.DisplayAlerts = False
before your DeleteSheet code and
Application.DisplayAlerts = True
after it.

Hope this helps,

Hutch

"Mikey" wrote:

I have DeleteSheet code at the end of my macro and the box always pops asking
if I want to Delete the Sheet. What is code to make it automatically close
or = True?
--
Mickey