Delete Sheet without display alert

[Adnane]

Hi,

i'm using a macro to delete all sheets (except two named ones) before the rest of it gets executed. this is to avoid having a lot of sheets after a couple of executions.

what i'm asking now is how to do it without having to confirm the deletion of each sheet manually.

i tried the Application.DisplayAlerts = False but it doesn't work and instead a get an error.

Regards,

Adnane

Micorosft North Africa

http://www.microsoft.com/northafrica

 

[Chattin]

Post your code and what error do you get? Application.DisplayAlerts=False should work