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?

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.

--

HTH

Bob

"Prof Wonmug" 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?

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

On Fri, 30 Apr 2010 18:49:01 +0100, "Bob Phillips"
wrote:

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.

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.

--
Rich Locus
Logicwurks, LLC


"Prof Wonmug" wrote:

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?
.

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"
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?

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



"Jim Cone"
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.
--
Jim Cone
Portland, Oregon USA

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.
--
HTH,

Barb Reinhardt



"Prof Wonmug" wrote:

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?
.