I'm guessing you protected the workbook.

Unprotect it.

BTW...........you cannot close some worksheets while the workbook is open.

You can only close entire workbooks, all sheets included.


Gord Dibben MS Excel MVP

On Tue, 22 Sep 2009 08:07:02 -0700, Cindy Sweeny <Cindy
wrote:

I have a spreadsheet that I use every day. today the worksheets are not
maximized on the screen and the red 'X' in the upper right hand corner of the
worksheets is missing. How do I get my red 'X' back to close the worksheets
while the spreadsheet is still open?