do not save in dialog box

[mdwnn7]

Hi

im writing a macro that copys data from an 7 original sheets (which are password protected) and saves them on 1 sheet to analyse a weeks worth of data
I have got as far as collecting the data, however when the macro goes to close the original sheets the "Save, Do not Save" dialog box comes up and asks for a manual prompt.
How can i put this in the macro as do not save?

Mick

[Arkadi]

how are you referencing the original workbook?

this would close the "active" workbook, modify as needed:

Please Login or Register  to view this content.

[stnkynts]

Does Turn off display alerts work? Example:

Please Login or Register  to view this content.

[mdwnn7]

Thanks Arkadi & stnkynts they both work'
I just need to think switch works best for this macro

[Arkadi]

either way should be fine, depending on what takes place after the close you may want to turn .displayalerts back on afterwards.