The VBA IDE will discard changes without warning

[Prof Wonmug]

I'm no expert, but I have been using VBA for years. Something just
happened that I can hardly believe.

I made a few minor changes, mostly cosmetic, to a UDF in a personal
add-in module. I usually save after every change (Ctrl-S). I guess I
was distracted and just closed the editor and Excel. When I reopened
the add-in module, the changes were not there.

As a test, I made a couple of changes and closed the editor without
saving. I got no warning that I had unsaved changes. The add-in file
time stamp did not change and when I reopened the module, the changes
were gone.

Did I change some setting by mistake?

Is there a way that I can get the IDE editor to warn me if I am about
to lose changes?

 

[Bob Phillips]

This is getting repetitive, but that shouldn't happen <g>

Even if you don't save in the VBIDE, when you close the workbook or close
Excel, it should ask you because the file has changed.

 

[Rich Locus]

Hello Prof:
I reviewed your question, and most of the hits I saw were dealing with
network drive issues. Are you running this from a network or saving the file
to a network? If so, then I would look at that.

I checked a couple of other ideas, such as an active
Application.DisplayAlerts = False, or changing the file to Read-Only, but
neither of those attempts created any issues.

 

[Jim Cone]

You could have code, someplace, that tells Excel not to save the workbook...
ThisWorkbook.Saved = True
or maybe something in the ThisWorkbook.BeforeClose event that does the same thing.
--
Jim Cone
Portland, Oregon USA




"Prof Wonmug" <[email protected]>
wrote in message I'm no expert, but I have been using VBA for years. Something just
happened that I can hardly believe.

I made a few minor changes, mostly cosmetic, to a UDF in a personal
add-in module. I usually save after every change (Ctrl-S). I guess I
was distracted and just closed the editor and Excel. When I reopened
the add-in module, the changes were not there.

As a test, I made a couple of changes and closed the editor without
saving. I got no warning that I had unsaved changes. The add-in file
time stamp did not change and when I reopened the module, the changes
were gone.

Did I change some setting by mistake?

Is there a way that I can get the IDE editor to warn me if I am about
to lose changes?

 

[Jim Cone]

Actually that should be...
Workbook_BeforeClose not ThisWorkbook.BeforeClose
Jim Cone



"Jim Cone" <[email protected]>
wrote in message
You could have code, someplace, that tells Excel not to save the workbook...
ThisWorkbook.Saved = True
or maybe something in the ThisWorkbook.BeforeClose event that does the same thing.

 

[Gord Dibben]

I have never been asked to save changes in my personal macros add-in when
closing Excel.

Personal.xls or any other workbook.......yes, I get asked.


Gord Dibben MS Excel MVP

 

[Barb Reinhardt]

I've seen this happen when I have two instances of Excel open and without
realizing it, changed the "read only" version, not the version that can be
edited.