View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Randy[_11_] Randy[_11_] is offline
external usenet poster
 
Posts: 18
Default 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