Weird. I did everything you said and it still isn't working. I have screen
shots I could send you, if there is an email address I could use. Is there?

"Trying to Understand" wrote:

I'm positive that we are trying to hide it instead of closing it. I've done
this many times for myself and have helped many others do this, too. That's
why I was so surprised. I will attempt your suggestions and let you know.

Many thanks for trying to help me!

"Dave Peterson" wrote:

If it doesn't ask you to save, then something else is going wrong.

You can save it via the VBE, though:

After you've hidden the personal.xls workbook
hit alt-f11 to get to the VBE
hit ctrl-r to see the project explorer
Select your project in that window
hit the floppy disk icon to save that workbook.

Or you could use:
Open the VBE
hit ctrl-g to see the immediate window
type this:
workbooks("personal.xls").save
and hit enter.

=========
Are you sure you're hiding and not closing the window???

You may want to look to see why the file isn't getting a prompt. It could be
another macro that's closing the personal.xls (without the prompt) or marking it
as already saved:

workbooks("Personal.xls").saved = true

Would tell excel not to bother asking.

Trying to Understand wrote:

Sorry; I didn't read your post completely before I responded.
Yes, we are using the Window, Hide command (after having made sure that
personal.xls is the active window). I donn't recall it asking us to save
changes, like it normally does. I know that it is supposed to do that.

"Dave Peterson" wrote:

How are you (or that user) trying to hide the window?

I'd try:
Make personal.xls the activeworkbook
Window|hide (in xl2003 menus)
Then close excel.

You should be prompted to save personal.xls -- make sure that you choose Yes so
that personal.xls remains hidden.

Trying to Understand wrote:

Has anyone ever heard of a personal.xls file that refuses to hide? I have a
user whose file will not stay hidden. It closes instead.

--

Dave Peterson


--

Dave Peterson