Events are not disabled
 

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
--
______
Regards,
Greg

Events are not disabled
 

You give almost no information but perhaps you want
application.displayalerts=false


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Greg" wrote in message
...
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
--
______
Regards,
Greg

Events are not disabled
 

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



In article ,
Greg wrote:

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

Events are not disabled
 

Exactly! Appreciate it!