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" <(E-Mail Removed)> wrote in message
news:8fbbefc5-06d3-4dfe-ad19-(E-Mail Removed)...
> 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!