Display Alerts Not Working

[aequitas1903]

Hi everyone,

I searched the forum and internet but couldn't find the exact solution for this.

I am running a macro which checks a value (the values I am checking have sheets named after them) If the sumif of the value is zero I am deleting the sheet. Anyways I used

ThisWorkbook.Application.DisplayAlerts = False

It was working before but I don't know what I have done to my excel. Right now, it is not working in my pc but it works in my colleagues pc. Pop-up comes and asks my everytime to delete the sheet. There is lots of sheets to be deleted and I can not say yes every time.

Do you have ideas why this is happening? Am I the chosen one

Thanks you in advance. Cheers.

 

[aequitas1903]

Hey again,

I fixed it by writing the "ThisWorkbook.Application.DisplayAlerts = False" code infront of sheet deletion code and "ThisWorkbook.Application.DisplayAlerts = True" after deletion is done.

If you still have any idea or suggestions, I will be happy to hear.

Cheers

 

[adam087]

What does your code currently look like?

/AJ