若你在原工作表中带宏,那就作如下修改:
Sub BF()
Dim msgResult, SheetName
SheetName = Format(Date, "m月d日备份")
On Error Resume Next
Debug.Print ThisWorkbook.Sheets(SheetName).Name
If Err.Number = 0 Then
msgResult = MsgBox("今天已经备份,是否重新备份?", vbOKCancel, "提示")
If msgResult = vbCancel Then
Exit Sub
Else
Application.DisplayAlerts = False
ThisWorkbook.Sheets(SheetName).Delete
End If
End If
On Error GoTo 0
Sheets.Add After:=Sheets(Sheets.Count)
Sheets("买卖记录").Cells.Copy ActiveSheet.Range("A1")
With ActiveSheet
.Name = SheetName
.Shapes(1).Delete
.UsedRange.Value = .UsedRange.Value
End With
Sheets("买卖记录").Activate
Application.DisplayAlerts = True
MsgBox "备份成功"
End Sub