Creating a Macro - Pop up Message appears when workbook is saved

[kron0120]

Hey everyone,

I'm looking to create a Macro in Excel 2010 that will create a pop up message for whenever the workbook is saved.

I've been playing around and have been able to create what I want with a Macro button that enables it. But looking for something that will activate when the workbook is saved and a pop up message box will appear with a reminder message for the Excel user to double check their work.

Is that something that is possible? Did some digging, but couldn't find exactly what I needed to get it to work. First time working with Macros so any help would be greatly appreciated!

Thanks - kron0120

 

[Joe4]

Welcome to the board!

Perhaps a "BeforeSave" or "AfterSave" event procedure would be in order here.
See: https://msdn.microsoft.com/en-us/library/office/ff840057.aspx
and: https://msdn.microsoft.com/en-us/library/office/ff836466.aspx

If you are unfamiliar with "event procedures", they are basically VBA procedures which run automatically based on some "event: happening (like saving a file). Chip Pearson has a good write-up on them here: Events In Excel VBA

 

[njimack]

You need to create a BeforeSave event in the ThisWorkbook module.

 

[John_w]

Welcome to MrExcel forums.

This can be done with the Workbook_BeforeSave event handler in the ThisWorkbook module:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    MsgBox "Saved: " & ThisWorkbook.FullName
End Sub

 

[kron0120]

Thanks everyone! I knew there was just one part I was missing.