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.
user whose file will not stay hidden. It closes instead.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
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.
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.
T
Trying to Understand
We are going to the Window menu and choosing, "Hide."
T
Trying to Understand
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.
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.
D
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.
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.
T
Trying to Understand
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!
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!
T
Trying to Understand
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?
screen prints I could show you ... is there an email address which I could
use to send them to you?
D
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?
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?
T
Trying to Understand
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?
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!
D
Dave Peterson
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?
T
Trying to Understand
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?
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.