Closing Workbook without saving Changes

I run a macro that opens onther workbbok and prints some sheets.
The workbook that i open also contains a macro that runs when opened. When the macro from the first workbook closes this it brings up a message box asking to save changes which i have to manually click.

I need a bit of code to not save the changes to the workbook or not to be asked.

Also should the code go in the first workbook (where the code is run from) or from the workbook that is being closed

Note that I am opening and closing muiltiple workbooks which i would like this to apply to

Cheers

Please Login or Register  to view this content.

will turn messages off (remember to turn back on at the end)

Please Login or Register  to view this content.

will close without saving, substitute your workbook name/variable. Sounds like it should be in the macro which opens the workbooks.

Thanks for that