Deleting sheets

[Brian Matlack]

Hi!
Before ending my macro I delete these two sheets but Excel gives me a
warning prompt before deleting the sheets that I must OK. Is there a
way to avoid the prompt and delete the sheets without interrupting the
code?

<start code>
Sheets("sheet1").Select
ActiveWindow.SelectedSheets.Delete
Sheets("sheet2").Select
ActiveWindow.SelectedSheets.Delete
<end code>

Thanks!!

 

[Chip Pearson]

You can use the Application.DisplayAlerts property to suppress
the message. E.g.,


Application.DisplayAlerts = False
' your code here
Application.DisplayAlerts = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Brian Matlack"
<[email protected]>
wrote in message
news:[email protected]...

 

[Brian Matlack]

You can use the Application.DisplayAlerts property to suppress
the message. E.g.,


Application.DisplayAlerts = False
' your code here
Application.DisplayAlerts = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Brian Matlack"
<[email protected]>
wrote in message

Thanks Chip!!

 

[Bob Phillips]

Application.DisplayAlerts = False

set back to True at the end.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Brian Matlack" <[email protected]>
wrote in message
news:[email protected]...