I went about it another way. I originally had ThisWorkbook.SaveCopyAs
I changed it to SaveAs and set the password and WriteResPassword to "
and now it seems to do what I need.

Thanks anyway e1, and have a super day!!!:cool

--
Message posted from http://www.ExcelForum.com