It shouldn't, but try
Option Explicit

Private Sub CommandButton2_Click()

    ActiveSheet.Copy
    With ActiveWorkbook.ActiveSheet
        .Columns("A:F").Value = Columns("A:F").Value
        .SaveAs Filename:= _
                "C:\flapricelist.xls", FileFormat:= _
                xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
                                                                                   , CreateBackup:=False
    End With
End Sub