Is there a way to save xlsm in another workbook as xlsx and remove all user form controls?
The code below work perfectly but I would like to remove the user form controls when saved in xlsx file
Dim Fname As String
Dim Fpath As String
Dim ws As Worksheet
Set ws = Sheet1
Fname = ws.Range("B1")
Fpath = Environ("Userprofile") & "\Desktop\"
.SaveAs FileName:=Fpath & Fname & " Billing Milestone", FileFormat:=xlOpenXMLWorkbook
MsgBox (Fname & " Billing Mileston has been saved to your desktop.")