Auto-Saving .XLA Code Changes?
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? |
Auto-Saving .XLA Code Changes?
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? |
Auto-Saving .XLA Code Changes?
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! |
All times are GMT +1. The time now is 06:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com