Delete unwanted sheet

[Brenda]

When I bring up any excel sheet that i created and go to close it out it
brings up another sheet that i have to close out. I don't know how this sheet
got put in but when i go to delete it i get a pop up message saying: this
worksheet must contain at least one visible worksheet;you must first insert a
new sheet or unhide a sheet that is already hidden. How can i get this sheet
out and delete it. No matter what excel sheet i bring up i always get this
now. Please help

 

[OssieMac]

Hi Brenda,

I think you might be confusing Worksheets with Workbooks.
Workbooks are the actual Excel file with 1 or more Worksheets (tabs across
the bottom).

Now in a Workbook, there must be at least 1 visible worksheet. If you try to
either delete or hide the last visible worksheet you get a message similar to
what you describe but it says this WORKBOOK (not worksheet) must
contain....etc.

 

[Brenda]

I understand the difference it is a totally seperate workbook i don't know
why it keeps coming up

 

[Sheeloo]

What is the name of the workbook which comes up? If it matches the name of
any add-in then try to disable that.

If not then check whether that file is in your XLSTART folder...
Excel 2003 default location...
C:\Program Files\Microsoft Office\OFFICE11\XLSTART

Excel version?

 

[Brenda]

okay i checked and it is not in my start up. i am using excel 2003. It is
names Personal.xls. It is funny because no matter what excel spreadsheet i
bring up when i close it, it brings that up and i have to close that too. Any
other suggestions?

 

[Sheeloo]

Did you look in
C:\Program Files\Microsoft Office\OFFICE11\XLSTART ?

Close Excel
Search for personal.xls and delete it

Your problem should be resolved...

If you want to retain it then when personal.xls opens -
choose Window|Hide and then close Excel. When prompted to save Personal
macro workbook, click Yes.

FYI - personal.xls is used to store macro which you want to be available in
all files... somehow it has got into your system...

 

[ShaneDevenshire]

Hi Brenda,

You might ask - where did this come from? If you record a macro, one of the
options is to store that macro in the Personal Macro Workbook. If you choose
that options, Excel immediately creates a file called Personal.xls and when
you first close out it askes you to save it. If you reponded yes Excel will
now open the Personal.xls file automatically everytime you start Excel.

The Personal Macro Workbook is machine specific so to speak, so if someone
used your machine before you, or while you were away, they might have created
the file.

Normally this workbook is hidden so you don't see its sheet, however, you
can choose Window, Unhide and display it. If you then exit Excel you will be
asked if you want to save it, if you respond Yes, it will be visible
everytime you open Excel.

Now, I know its probably too late, but before you delete it from the
\XLStart folder you should consider whether it contains any macros you
want/need. For example, has anyone created a macro for you to help you do
some task easily? If so they may have put it into the Personal.xls file.


If any of this is helpful,, please click the Yes button.