Events are not disabled

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

Guest

hi,

I'm deleting a sheet w/ data via code and the following is not working??

Application.EnableEvents = False
wks.Delete
Application.EnableEvents = True

Thank you for your suggestions
 
You give almost no information but perhaps you want
application.displayalerts=false
 
Works fine for me. What are you expecting to happen?

If you don't want to see the *alert*, use

On Error Resume Next
Application.DisplayAlerts = False
wks.Delete
Application.DisplayAlerts = True
On Error GoTo 0
 
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

Taking control from Option Button into RefEdit in Excel 2010 behaving oddly 4
Addin not allowing thisworkbook.save in before save event 3
Change_Event troubles, no error & no work. 6
Application.EnableEvents = False not working 2
Sheet change event not triggering macro 3
Deleting Worksheets 3
Supress message window 1
Force input in multiple cells in Excel form 8

Back
Top