Macro to force delete tabs

  • Thread starter Thread starter Randy
  • Start date Start date
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
 
Application.DisplayAlerts = False
Activesheet.Delete ' or sheets.Delete
Application.DisplayAlerts = True
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to force macros refer to ActiveWorkbook 2
Forcing Macros to Run 2
Trigger Macro on Worksheet Delete 1
Force "Enable" Macros on Userform 5
macro 4
Macro Debug on Pivot Table 5
Question on pivot tables 1
Macro to delete rows 3

Back
Top