macro to close file and not save changes

[Ramzes]

Hello All,

I am using a spreadsheet that opens during a macro run and I wonder if I can do so and chose don't save without the window to pop out?

Is there a possibility?

[Sintek]

Not sure what you mean but this suppresses the save window...

Application.DisplayAlerts = False

[Ramzes]

Hi,

Thank you for the suggestion.

I have wrapped it around with:

Application.DisplayAlerts = False

and

Application.DisplayAlerts = True

to see it working as I wanted it.

Thank you.

[bakerman2]

Something like this maybe.

    Application.DisplayAlerts = False
    Workbooks("yourworkbookname").Close False
    Application.DisplayAlerts = True