macro comand question

  • Thread starter Thread starter Roger
  • Start date Start date
R

Roger

I've recorded a macro that deletes a worksheet tab within a workbook, the
problems I'm having is once the macro is complete I get an excel message that
says "Data may exsist in the sheet selected for deletion. to permanently
delete the data, press Delete"
Question: what is the comand in VBA to select and "push" the delete button?

thanks in advance.
 
Roger

Add this to your code:

Application.DisplayAlerts = False

Good luck.
Ken
Norfolk, Va
 
Back
Top