It seems to me that in your macro you have told the cells to be u
locked in your statement Lock=false but you do not turn it on agai
afterwards, i'm assuming that the workbook you save does not have th
"lock cells" check box checked and this is why they remain unlocked bu
your original worksheet is locked.

I'm new to all this myself but i would try turning the lock=true o
before saving the new file.

HTH

Simo

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