deleting worksheet

  • Thread starter Thread starter Laurent M
  • Start date Start date
L

Laurent M

Hello,

i would like to know how i can delete a worksheet
automaticaly without confirming it in the dialog box.

Thanks.
 
You need VBA, and to set displayalerts off

Application.DisplayAlerts = False
Worksheets("Sheet1").Delete
APplication.DisplayAlerts = True

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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

Transfer a figure in a cell from worksheet to another 3
Deleting rows which contain blank cells 11
Saving collected data? 1
Linking data on different worksheets 1
excel 2
Excel 2007 Format Question 3
another macro query - deleting a worksheet within a query 2
Can Excel send automaticaly e-mails depends on cell value 2

Back
Top