Save warning sign

[Guest]

When exiting a workbook that I've made changed to for some reason I no longer receive a pop-up message asking me if I'd like to Save Changes. When I open the workbook again, it only has the old, unsaved version. Does anyone know how I can get the warning message to return so that I don't lose my changes?

 

[Dave Peterson]

Any chance that you have a macro that's "helping" you.

There are lots of posts in the newsgroups asking for ways to prevent saving of a
workbook.

First thing I'd do is open that file with macros disabled and see if that
behaved differently.

 

[Guest]

Thanks for helping - when I open Excel with Macros disabled it is back to normal and reminds me to save changes when I exit. Any idea what to do to get the save reminder when I then have to enable macros for my work?

 

[Dave Peterson]

I should have asked if this happens on all workbooks or just one?

If it's just one: Can you find the developer of the workbook and poke him/her
until they change it?

If the project (where the code is kept) is protected, you're kind of at their
mercy.

But you could try this:
open the workbook
hit alt-F11 to get to the VBE
hit ctrl-R to see the project explorer (like windows explorer)
Find your workbook/project
should look like: VBAProject (yourfilename.xls)

Double click on it.

If you're prompted for a password, get your poking finger ready!

But if you're not prompted, you can look for code that stops the save.

(This can be dangerous--you could break something integral to the workbook--so
do this against a copy.)

The first place I'd look is under the ThisWorkbook module.

There could be an event named Workbook_beforesave that tells excel not to even
try saving the file. And look under workbook_beforeclose, too. (But it could
be in lots of spots.)

(Debra Dalgleish has some pictures of the project explorer (for a different
purpose) at:
http://www.contextures.com/xlfaqMac.html#NoMacros
You may want to look there just to become familiar with the lay of the land.)

After that, if you think you see what you need to change, but are hesitant, post
back. I think I'd post in a new thread with an explanation of what you need.
(There's a chance that you might get lost if you post back to this same thread.)

========
As a workaround before you get the developer to change:

Try this to see if it works.
Right before you want to save the file,
hit alt-F11 to get back to the VBE
hit ctrl-G to see the immediate window
type this and hit enter

application.enableevents = false

Back to excel and save the file.

Then alt-f11 to get back to the VBE and reenable events. (You might need it for
the workbook???)

application.enableevents = true

===
This should work if the project is protected, too.

It's just a pain to do each time and it kind of destroys the design of the
developer. (There must have been a reason he/she did it this way.)

====================

If this (no save prompt) happens for all workbooks, post back with how you close
the workbook. (maybe one of the icons has been take over by a "helpful"
program.)