Code to OK DeleteSheet automatically

  • Thread starter Thread starter Mikey
  • Start date Start date
M

Mikey

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?
 
Put Application.DisplayAlerts = False
before your DeleteSheet code and
Application.DisplayAlerts = True
after it.

Hope this helps,

Hutch
 
Back
Top