Macro to force delete tabs
 

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

Macro to force delete tabs
 

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

--
Regards,
Tom Ogilvy

"Randy" wrote in message
...
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