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?

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" wrote in message
...
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?

On Jun 4, 11:18 am, "Peter T" <peter_t@discussions wrote:
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!