解决方法如下:
Sub CheckWorkbookSaved()
If ActiveWorkbook.Saved = True Then
MsgBox "The active workbook is saved."
Else
MsgBox "The active workbook is not saved."
End If
End Sub
Sub CheckThisWorkbookSaved()
If ThisWorkbook.Saved = True Then
MsgBox "The workbook is saved."
Else
MsgBox "The workbook is not saved."
End If
End Sub
Private Sub Workbook_Open()
If Me.Saved = True Then
MsgBox "The workbook is saved."
Else
MsgBox "The workbook is not saved."
End If
End Sub
注意:以上代码示例中的消息框只是为了演示目的而添加的,您可以根据需要进行修改。