Do action Before Save

I've found dozens of examples to complete an action before save such as:

Private Sub workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim lReply As Long
If SaveAsUI = True Then
lReply = MsgBox("Do you wish to save this workbook?", vbQuestion + vbOKCancel)
Cancel = (lReply = vbCancel)
If Cancel = False Then Me.Save
Cancel = True
End If
End Sub

...but when I insert this into my VBA code window and save, nothing happens. If I am reading this right, when I save the wkbk, a message should pop up, right?

I'm terrible at VBA but I understand the logic.

All I want to do is have an action triggered when I hit save. Is that even possible?

Thanks