Delete a Sheet without dialog

K

Ken Loomis

I am using this to delete a worksheet:

Sheets("Replace Info").Delete

however, that causes a warning dialog box. How can I delete that worksheet
without a dialog box?
 
M

Mike Fogleman

Application.DisplayAlerts = False
Sheets("Replace Info").Delete
Application.DisplayAlerts = True

Mike F
 
G

Gord Dibben

Ken

Surround with

Application.DisplayAlerts = False

Sheets("Replace Info").Delete

Application.DisplayAlerts = True


Gord Dibben Excel MVP
 
G

Guest

Just to be safe you should probably add

Application.DisplayAlerts = False
on error resume next
Sheets("Replace Info").Delete
Application.DisplayAlerts = True

or add this line into an existing error handler if you have one
Application.DisplayAlerts = True

Otherwise if the delete fails then you never turn the alerts back on whcih
can be a bad thing...
 

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

Automating key strokes to a dialog box 2
Worksheet Delete method's dialog box 3
VBA code causes Find and Replace dialog box to lose focus 2
Delete worksheet - dialog box showing 1
Delete worksheet without confirmation 1
Suppress Delete Sheet Warning 1
Allow Users to Unfreeze Panes in a Protected Workbook/Sheet 2
Macro to launch the Activate dialog box? 2

Top