It seems I didn't know how to post codes back then :). I always like to recap the question so there is no confusion as to what the code does.
So you have a Master workbook, which has workbook names in column A with a header. Now you want to copy the Master workbook and rename it according to the names mentioned in column A. The copied and renamed workbooks should not contain the code.
For that give the following code a try, but only after replacing the file path:
Dim x As Integer
Application.DisplayAlerts = False
x = 2
ActiveWorkbook.SaveAs Filename:="C:\Documents\" & Range("A" & x).Value & ".xlsx", FileFormat:=xlOpenXMLWorkbook
x = x + 1
Loop Until Range("A" & x).Value = vbNullString
Application.DisplayAlerts = True