Hello everyone,

I have been presented with a problem by several users. When they are
working on a spreadsheet and click the "X" (in the upper right corner)
to close the spreadsheet (not close Excel), they cannot re-open the
spread sheet later in that Excel session. They must close Excel and
then restart Excel to open the spreadsheet.

I poked around a few mins and found that the spreadsheet is actually
being hidden when they click the "X". Clicking "window-unhide" brings
the spreadsheet back.

However, if they click "File-close", the spreadsheet closes.

How can I make the spreadsheet(s) acutally close when the user clicks
the "X"?

This does not happen with all the spreadsheets, only a few.

Using Excel XP and 2003.

Thanks,


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Bob,

I haven't heard of this one. Y ou might want to search the knowledge base
at microsoft.com. Some possibilities:

Look for macros. If your macro security is set to low, you might not know
they're there.

Try re-registering Excel with windows. End Excel. Start - Run - excel.exe
/regserver. Then start Excel normally.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"bobfronk" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Hello everyone,
>
> I have been presented with a problem by several users. When they are
> working on a spreadsheet and click the "X" (in the upper right corner)
> to close the spreadsheet (not close Excel), they cannot re-open the
> spread sheet later in that Excel session. They must close Excel and
> then restart Excel to open the spreadsheet.
>
> I poked around a few mins and found that the spreadsheet is actually
> being hidden when they click the "X". Clicking "window-unhide" brings
> the spreadsheet back.
>
> However, if they click "File-close", the spreadsheet closes.
>
> How can I make the spreadsheet(s) acutally close when the user clicks
> the "X"?
>
> This does not happen with all the spreadsheets, only a few.
>
> Using Excel XP and 2003.
>
> Thanks,
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>