Auto-Saving .XLA Code Changes?

[PeteCresswell]

I keep burning myself by not clicking File | Save after making changes
to VBA code in a .XLA.

Looked through the options, but couldn't find anything that would auto-
save any code changes - or at least prompt me.

Doesn't seem right - so I'm probably missing something.

Can anybody elucidate?

 

[Peter T]

One idea perhaps, while developping -

Private Sub Workbook_BeforeClose(Cancel As Boolean)
If Not ThisWorkbook.Saved Then
If MsgBox("Do you want to save" & vbCr & _
ThisWorkbook.FullName, vbYesNo) = vbYes Then
Me.Save
End If
End If
End Sub

Regards,
Peter T

 

[PeteCresswell]

One idea perhaps, while developping -

If Not ThisWorkbook.Saved Then
If MsgBox("Do you want to save" & vbCr & _
ThisWorkbook.FullName, vbYesNo) = vbYes Then
Me.Save
End If
End If
End Sub

That's the ticket.

Thanks!