error boxes

[andrew299]

Hello
I would like to know how to turn off error messages. I have a macro that deletes sheets in a workbook, but everytime I run it for every sheet I get a message - This sheets will be permanently deleted -yes or no? or something

How do I stop this appearing because it is annoying when I have several sheets to delete.

Thanks
Andrew299

 

[xlbo]

Put
Application.displayalerts = false
before you delete the sheets
and then
Application.displayalerts = true
afterwards

Make sure you turn them back on or they will be off for the rest of the session Rgds
~Geoff~