J
JohnR
Whenever I open Excel I get 2 blank new sheets, Book1 & Book2. If I leave
Personal.XLS unhidden, I get only Book1. Am I goofy or what?
Thanks
John
Personal.XLS unhidden, I get only Book1. Am I goofy or what?
Thanks
John
No Change Dave. No entry at all in Tools|Options|General tab|At Start up,
open all files in:
Only on XL Start Folder, that's in Program Files\Microsoft Office03\Office
11.
However, for what its worth, my default directory for saving files is
C:\MS_Spreadsheets. No XLStart folder their either.
I'm totally stumped.
Checked macros too, none there either.
??????????
John
Still no luck ! I'll try posting in one of the other forums. Thanks for
your help though
John
HOLD ONTO YOUR HAT.
I just did a "Copernic" desktop search, and it brought up a 3 year old
e-mail with "Workbook" in it. After reading it, I recall having a problem a
few years back, with not getting a blank workbook on opening. I guess I
checked the forums, and got this answer:
"
John
From Excel, hit Alt-F11 to open the VBE. On the left side is the Project
Explorer. One of the project listed should be Personal.xls. Expand the
project if necessary and open the folder called Microsoft Excel Objects. In
that folder, there is an object called ThisWorkbook. Double click that and
it will open a code pane for that module. At the top of that code pane,
there are two drop down boxes. From the left one, select Workbook and from
the right select Open (it may select that for you automatically). This will
put the Sub and End Sub statement in the code pane. You type in the rest of
the code.
The ThisWorkbook module is actually a special kind of Class Module. It
already has all the class information coded into it, so you have access to
all of the events.
Let me know if you need more help.
Dick
-----Original Message-----
From: John [mailto[email protected]]
Sent: Wednesday, September 25, 2002 2:16 PM
To: Dick Kusleika
I just deleted it, and "Voila"! Problem solved Thanks to Dick Kusleika,
wherever he is.
Thanks Again You All
John
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.