Im opening a different workbook and Im copying a sheet from it. Thought
I opened it as readonly, but sometimes it still asks if I want to save
the changes.

Set sourceWb = Workbooks.Open(filepath, True, False)
........
..............
(can I write something like sourceWb.Don'tSave or something)

sourceWb.Close


--
Newbie80
------------------------------------------------------------------------
Newbie80's Profile: http://www.excelforum.com/member.php...o&userid=25946
View this thread: http://www.excelforum.com/showthread...hreadid=394562