Sheet that never closes
 

I have an Excel sheet that I've had since version 95. For this explanation I
will call it Names. If I open Names make changes save and close Names but
remain in Excel and open another sheet. The sheet Names will automatically
open again and when I shut down Excel will ask me if I want to save Names
again. I have no idea why.

If I close Names, exit Excel, then reopen Excel and open another sheet the
above does not happen. Sometimes it can be a PITA.


Regards
Michael Koerner

Sheet that never closes
 

On Jan 31, 2:02*pm, "Michael Koerner" wrote:
I have an Excel sheet that I've had since version 95. For this explanation I
will call it Names. If I open Names make changes save and close Names but
remain in Excel and open another sheet. The sheet Names will automatically
open again and when I shut down Excel will ask me if I want to save Names
again. I have no idea why.

If I close Names, exit Excel, then reopen Excel and open another sheet the
above does not happen. Sometimes it can be a PITA.

Regards
Michael Koerner

Try to see if the sheet is hidden after you close it. Unhide the
workbook and close it. It somethimes helps. Otherwise, I think it
there is a bug in the sheet. Try to copy the contents to an other
sheet and save it there.

Hope it works

Regards

Sheet that never closes
 

The only sheet that is hidden after I close it is Personal.xlsb Have tried
copying to another sheet. that does not seem to matter.

--
Regards
Michael Koerner


"Master Blaster" wrote in message
...
On Jan 31, 2:02 pm, "Michael Koerner" wrote:
I have an Excel sheet that I've had since version 95. For this
explanation I
will call it Names. If I open Names make changes save and close Names but
remain in Excel and open another sheet. The sheet Names will
automatically
open again and when I shut down Excel will ask me if I want to save Names
again. I have no idea why.

If I close Names, exit Excel, then reopen Excel and open another sheet
the
above does not happen. Sometimes it can be a PITA.

Regards
Michael Koerner

Try to see if the sheet is hidden after you close it. Unhide the
workbook and close it. It somethimes helps. Otherwise, I think it
there is a bug in the sheet. Try to copy the contents to an other
sheet and save it there.

Hope it works

Regards

Sheet that never closes
 

Just to clarify.

Personal.xlsb is a workbook, not a worksheet.


Gord Dibben MS Excel MVP

On Sun, 31 Jan 2010 15:12:37 -0500, "Michael Koerner"
wrote:

The only sheet that is hidden after I close it is Personal.xlsb Have tried
copying to another sheet. that does not seem to matter.

Sheet that never closes
 

typo on my part




"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Just to clarify.

Personal.xlsb is a workbook, not a worksheet.


Gord Dibben MS Excel MVP

On Sun, 31 Jan 2010 15:12:37 -0500, "Michael Koerner"
wrote:

The only sheet that is hidden after I close it is Personal.xlsb Have tried
copying to another sheet. that does not seem to matter.