Disable Worksheet Delete Dialog

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a VBA macro that needs to delete a worksheet but the confirmation
dialog comes up when run. Is there a way to disable this dialog.

Thanks,
Greg
 
Greg,

Try something like

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
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

Macro Security 1
Worksheet Delete method's dialog box 3
Delete worksheet - dialog box showing 1
Automating key strokes to a dialog box 2
How to delete Excel worksheet using VBA without delete dialog? 4
VBA code causes Find and Replace dialog box to lose focus 2
Suppress Error Dialog: "Data may exist in the sheet(s) selected for deleting...." 2
Notify user macros are disabled. 3

Back
Top