close

I maen you can not see it. This is only happening with one file. I do not
get any error message. It opens excel (or if I do from excel it quot;appears to
be openingquot; ) - it has a password and YES I am sure I know it and excel
accepts it. Excel ask if I want read-only and it does not matter whether I
say yes or no.

In excel the file is listed under the File menu, but not under the Window
menu. When I close excel it asks if I want to save changes for this file,
which I have done nothing to!

Can you do window|Unhide?
(Maybe it opens hidden??)

If that doesn't work, you can double check that it actually opened by:
1. Go into the VBE (use alt-f11)
2. Hit ctrl-r to see the project explorer
3. If you don't see something that looks like your filename, then it's not
open.
It may look like:
VBAProject (YourFileNameHere.xls)
(If it's open)

===
I'm betting that the window was hidden by mistake.

And this is a normal .xls file--not an addin (.xla), right?

Fred Zack wrote:
gt;
gt; I maen you can not see it. This is only happening with one file. I do not
gt; get any error message. It opens excel (or if I do from excel it quot;appears to
gt; be openingquot; ) - it has a password and YES I am sure I know it and excel
gt; accepts it. Excel ask if I want read-only and it does not matter whether I
gt; say yes or no.
gt;
gt; In excel the file is listed under the File menu, but not under the Window
gt; menu. When I close excel it asks if I want to save changes for this file,
gt; which I have done nothing to!

--

Dave Peterson



quot;Dave Petersonquot; wrote:

gt; Can you do window|Unhide?
gt; (Maybe it opens hidden??)
gt;
gt; If that doesn't work, you can double check that it actually opened by:
gt; 1. Go into the VBE (use alt-f11)
gt; 2. Hit ctrl-r to see the project explorer
gt; 3. If you don't see something that looks like your filename, then it's not
gt; open.
gt; It may look like:
gt; VBAProject (YourFileNameHere.xls)
gt; (If it's open)
gt;
gt; ===
gt; I'm betting that the window was hidden by mistake.
gt;
gt; And this is a normal .xls file--not an addin (.xla), right?
gt;
gt; Fred Zack wrote:
gt; gt;
gt; gt; I maen you can not see it. This is only happening with one file. I do not
gt; gt; get any error message. It opens excel (or if I do from excel it quot;appears to
gt; gt; be openingquot; ) - it has a password and YES I am sure I know it and excel
gt; gt; accepts it. Excel ask if I want read-only and it does not matter whether I
gt; gt; say yes or no.
gt; gt;
gt; gt; In excel the file is listed under the File menu, but not under the Window
gt; gt; menu. When I close excel it asks if I want to save changes for this file,
gt; gt; which I have done nothing to!
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Well it was hidden in Excel. I had checked this under Attributes in the
Properties menu item when you left click file anme in windows explorer.
Hidden was not checked there! But when I did unhide form excel it appeared.
Guess Properties does not have it right!

Thanks, Dave.

You can hide a file from showing up in windows explorer by using that file's
property (outside of excel).

Actually, you can mark the file (using windows explorer) as being hidden, but if
the user chooses to show hidden files, they can.

This hidden property for files is separate and distinct from Window|hide in
excel.
Fred Zack wrote:
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Can you do window|Unhide?
gt; gt; (Maybe it opens hidden??)
gt; gt;
gt; gt; If that doesn't work, you can double check that it actually opened by:
gt; gt; 1. Go into the VBE (use alt-f11)
gt; gt; 2. Hit ctrl-r to see the project explorer
gt; gt; 3. If you don't see something that looks like your filename, then it's not
gt; gt; open.
gt; gt; It may look like:
gt; gt; VBAProject (YourFileNameHere.xls)
gt; gt; (If it's open)
gt; gt;
gt; gt; ===
gt; gt; I'm betting that the window was hidden by mistake.
gt; gt;
gt; gt; And this is a normal .xls file--not an addin (.xla), right?
gt; gt;
gt; gt; Fred Zack wrote:
gt; gt; gt;
gt; gt; gt; I maen you can not see it. This is only happening with one file. I do not
gt; gt; gt; get any error message. It opens excel (or if I do from excel it quot;appears to
gt; gt; gt; be openingquot; ) - it has a password and YES I am sure I know it and excel
gt; gt; gt; accepts it. Excel ask if I want read-only and it does not matter whether I
gt; gt; gt; say yes or no.
gt; gt; gt;
gt; gt; gt; In excel the file is listed under the File menu, but not under the Window
gt; gt; gt; menu. When I close excel it asks if I want to save changes for this file,
gt; gt; gt; which I have done nothing to!
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;
gt;
gt; Well it was hidden in Excel. I had checked this under Attributes in the
gt; Properties menu item when you left click file anme in windows explorer.
gt; Hidden was not checked there! But when I did unhide form excel it appeared.
gt; Guess Properties does not have it right!
gt;
gt; Thanks, Dave.

--

Dave Peterson

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()