Automatic dialog box selections

[MrKowz]

I am writing a VBA macro right now that opens and closes multiple workbooks and worksheets. Is there any command I can put into my macro that will automatically tell Excel it is OK to delete this worksheet and to not save the workbook I am trying to close?

Basically, I have:

Windows("Filename<WORKBOOKNAME>").Activate
ActiveWindow.Close

and I want to bypass the confirmation box that comes up.

Any ideas would be much appreciated.

 

[Jonmo1]

Welcome to the board...

Try

Application.DisplayAlerts = False


Set back to TRUE at the end of your code..

 

[MrKowz]

Perfect! Worked like a charm! Thanks for the info, and thank you for the welcome; I will likely be posting here every so often, as I am developing many macros for my employer.