Macro to force delete tabs

R

Randy

Hi,

i realize this is a lame VB question, but I can't find
the way to force the sheets.delete function to skip
the "are you sure" dialog box. Basically, I want a
function at the start of my pivot table macro to do a "if
exist, then delete; else create"

Any code snippets out there that do this?

thanks,
Randy
 
T

Tom Ogilvy

Application.DisplayAlerts = False
Activesheet.Delete ' or sheets.Delete
Application.DisplayAlerts = True
 
Top