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
- May 16 Wed 2007 20:37
Open an excel file but it does not display
close
全站熱搜
留言列表
發表留言