delete sheet

  • Thread starter Thread starter nIGEL bENNETT
  • Start date Start date
N

nIGEL bENNETT

How can I code it to delete a sheet without the warnings

Thanks
 
Nigel

Sub QuietDelete
With Application
.DisplayAlerts = False
Worksheets("Sheet1").Delete
.DisplayAlerts = True
End With
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
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

clear all sheets code 4
Sheet delete is disabled, how to enable? 1
Delete line in sheet, deletes same line in add'l sheets 1
VBA to automatically cut, paste entire row based on date input and delete row 0
Warning off by deleting a sheet 1
restrict user from deleting a sheet 2
Code to format cells on several worksheets 2
Excel Move or Copy Stopped Working? 0

Back
Top