Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Owltrax
 
Posts: n/a
Default Excel startup and named worksheets

Hi! I'm baffled! I need some help!

When I startup Excel, instead of getting a blank worksheet, I get TWO
worksheets the first one titled: Personal.xls:1 and behind it is the second
one titled: Personal.xls:2.

I want a blank, untitled worksheet to come up when I start Excel.

I have looked through the help files and it points me to look in the General
tab in Options at the "at startup, open all files in:" block and clear it,
but there is nothing in that box to clear. There is also nothing in the
XLSTART.folder for me to clear.

Thanks in advance!
Kat
  #2   Report Post  
Dino
 
Posts: n/a
Default Excel startup and named worksheets

You probably have a personal macro stored in Excel. To check this, go to
Tools, Macro, Macros and see if there is one there. If you don't want it,
delete it. Then, hide the Personal.xls though Window, Hide. Close Excel and
if it asks do you want to save Personal.xls, choose Yes.

Dino



"Owltrax" wrote in message
...
Hi! I'm baffled! I need some help!

When I startup Excel, instead of getting a blank worksheet, I get TWO
worksheets the first one titled: Personal.xls:1 and behind it is the
second
one titled: Personal.xls:2.

I want a blank, untitled worksheet to come up when I start Excel.

I have looked through the help files and it points me to look in the
General
tab in Options at the "at startup, open all files in:" block and clear it,
but there is nothing in that box to clear. There is also nothing in the
XLSTART.folder for me to clear.

Thanks in advance!
Kat



  #3   Report Post  
Owltrax
 
Posts: n/a
Default Excel startup and named worksheets

Thank you very much Dino! The hiding part worked!

Yes, at one time I did have a macro, but I deleted it and when I went to
macros to make sure; it is not there, so somehow I got things really mixed
up, but it works now, so THANKS AGAIN!

Kat

"Dino" wrote:

You probably have a personal macro stored in Excel. To check this, go to
Tools, Macro, Macros and see if there is one there. If you don't want it,
delete it. Then, hide the Personal.xls though Window, Hide. Close Excel and
if it asks do you want to save Personal.xls, choose Yes.

Dino



"Owltrax" wrote in message
...
Hi! I'm baffled! I need some help!

When I startup Excel, instead of getting a blank worksheet, I get TWO
worksheets the first one titled: Personal.xls:1 and behind it is the
second
one titled: Personal.xls:2.

I want a blank, untitled worksheet to come up when I start Excel.

I have looked through the help files and it points me to look in the
General
tab in Options at the "at startup, open all files in:" block and clear it,
but there is nothing in that box to clear. There is also nothing in the
XLSTART.folder for me to clear.

Thanks in advance!
Kat




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Startup Engineer_Dan Excel Worksheet Functions 1 October 25th 05 01:24 AM
Urgent Help Required on Excel Macro Problem Sachin Shah Excel Discussion (Misc queries) 1 August 17th 05 06:26 AM
Auto-displaying a template when Excel is launched Heidi Excel Discussion (Misc queries) 1 July 28th 05 03:10 AM
Excel opens with a Analysis folder istead of worksheet rantoine Excel Discussion (Misc queries) 7 March 29th 05 01:23 PM


All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"