Thank you all for your suggestions.

Leith
Your code worked like a charm for my needs. Thank you very much. Once
the file is saved under the new name I would like to close the original
file named Master Template without saving changes. I added the code
below to the end of the code you provided but for some reason the
original file remains open. Any suggestions?

Thanks again
Ed



Return

Windows("Master Template.xls").Activate
ActiveWorkbook.Close SaveChanges:=False
Application.DisplayAlerts = True
End Sub


--
nuver
------------------------------------------------------------------------
nuver's Profile: http://www.excelforum.com/member.php...o&userid=10036
View this thread: http://www.excelforum.com/showthread...hreadid=482918