macro comand question

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.
 
K

krcowen

Roger

Add this to your code:

Application.DisplayAlerts = False

Good luck.
Ken
Norfolk, Va
 

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

Top