Removing Dialog Box

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

Guest

Hi,

I have a macro that involves deleting a sheet. However a
dialog box asking whether the user should proceed with
deletion appears, which is very annoying for users. Is
there a way to stop this from appearing, either
programmatically or by altering settings.

I am using Excel 2002 and VBA.

Thanks in Advance
 
Application.DisplayAlerts = False
activesheet.Delete
Application.DisplayAlerts = True
 
Thanks for the quick response!

Cheers
-----Original Message-----
Application.DisplayAlerts = False
activesheet.Delete
Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy




.
Click to expand...
 
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

Automating key strokes to a dialog box 2
Dialog Box Buttons 1
Marco to open the "Customer Auto filter dialog box" 4
Auto Filter - Custom Auto Filter 4
Custom Document Properties in Word documents and Excel workbooks 13
Worksheet Delete method's dialog box 3
DREAM FEATURE: A macro that moves a row but asks me where to move it 18
Series of custom dialog boxes 1

Back
Top