Gord has brought this to us :
OP stated he wanted to close the source workbook and say NO to saving.

I try to close the source workbook,
but get a message box stating if I want to save changes to the
workbook. I want the VBA script to say no.

Just complying with his wishes.


Gord

So why not use the SaveChanges arg for the Close method? Surely this
would be preferable over adding code to the xls so it fires a security
warning when opened. Also, it occupies the same line of code, obviating
the need to turn DisplayAlerts off/on and so saves the extra
processing.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc