I want to copy and save a worksheet "Template", below VBA is working good, but it is copying also the formulas, I want only cell values of above work to be copied and saved.
Thanks
Private Sub CommandButton1_Click() ' Save Excel Copy
Dim FileName As String
Dim FilePath As String
Dim NewBook...