Is there a way to trap whether the user "saved" using the icon, ctrl+s, or
file save? I'd like to set a Boolean if they do.

I'm trying to separate that behavior vs. saying yes to "do you want to save
changes?" when they close a file - is that possible?

Thanks in advance!

Every workbook as a saved property that will tell you if the workbook has
been saved or not. Try this code to see

Sub test()
if ThisWorkbook.Saved = true then
msgbox "Saved"
else
msgbox "Not Saved"
end if
End Sub

--
HTH...

Jim Thomlinson


"Patti" wrote:

Is there a way to trap whether the user "saved" using the icon, ctrl+s, or
file save? I'd like to set a Boolean if they do.

I'm trying to separate that behavior vs. saying yes to "do you want to save
changes?" when they close a file - is that possible?

Thanks in advance!