Personal.xls Will Not Hide

  • Thread starter Thread starter Trying to Understand
  • Start date Start date
T

Trying to Understand

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.
 
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.
 
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.
 
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!
 
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?
 
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?
 
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 said:
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!
Click to expand...
 
I responded in a different branch in this thread.
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?
Click to expand...
 
Okay; thanks. I'll try that next.

Dave Peterson said:
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?
Click to expand...
 
Back
Top