Personal.xls Will Not Hide

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.

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

We are going to the Window menu and choosing, "Hide."

"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

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

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

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

Weird. I've done everything you've said and it still isn't working. I have
screen prints I could show you ... is there an email address which I could
use to send them to you?

"Trying to Understand" wrote:

We are going to the Window menu and choosing, "Hide."

"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

No thanks. I don't think it would help.

Are you sure you're opening the save version of personal.xls that you've just
saved?

Open excel so that personal.xls is visible.
go into the VBE and show the immediate window.
type this and hit enter
?workbooks("personal.xls").fullname
make a note of the path and filename.

Then save it once more using the .save line in the immediate window

The close excel and reopen it.
Go into the VBE and do the .fullname stuff again.

Do they match?

Trying to Understand wrote:

We are going to the Window menu and choosing, "Hide."

"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

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

I responded in a different branch in this thread.

Trying to Understand wrote:

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


--

Dave Peterson