Private Sub CommandButton1_Click()
Sheets("blad1").Copy
With ActiveWorkbook
Application.ScreenUpdating = False
Application.DisplayAlerts = False
.SaveAs "C:\Users\blabla\Desktop\excel test\" & Format(DateValue(Now - 8.5 / 24), "dd-mm-yyyy") & ".xls"
ActiveSheet.Copy After:=ActiveSheet
With ActiveSheet
.Range("AE1").Delete
.Shapes("CommandButton1").Delete
End With
Application.DisplayAlerts = True
End With
ThisWorkbook.Save
Call VerwijderFomules
.Close
Application.ScreenUpdating = True
End Sub
Sub VerwijderFormules()
Dim o_xlsmap As Workbook, o_xlsbld As Worksheet, o_xlscel As Range, a_calculation As Long
Application.ScreenUpdating = False
Application.DisplayAlerts = False
If Workbooks.Count = 0 Then Exit Sub
Set o_xlsmap = ActiveWorkbook
Application.ScreenUpdating = False
a_calculation = Application.Calculation
Application.Calculation = xlCalculationManual
Application.Calculate
On Local Error GoTo Foutje
For Each o_xlsbld In o_xlsmap.Worksheets
For Each o_xlscel In o_xlsbld.UsedRange
If o_xlscel.HasFormula Then
o_xlscel.Value = o_xlscel
End If
Next o_xlscel
Next o_xlsbld
Set o_xlsmap = Nothing
Foutje:
Application.ScreenUpdating = True
Application.Calculation = a_calculation
End Sub