MVPs- Your suggestions were right on. I was experiencing the same problem-
due to enabled Protection. I had forgotten at one point that this protection
was enabled. The previous user may not realize protection was enabled at
some point in the past (i.e. if the data was copied into a new, blank
workbook, the protection carries over. Maybe a previous user has enabled
it?) Since the owner is not asked for a password upon opening the workbook,
it's not immediately apparent. Also- I found that you do not receive any
sort of error or confirmation message if you have entered the wrong or the
right password at the Disable Protection box... If it's incorrect, only a
refreshed, blank password field. If you enter the correct passoword, the
password field (screen) disappears. Luckily- I got it on the third guess,
password box simply went away and the minimize and maximize buttons returned.


"Dave Peterson" wrote:

The only two times I've seen a window without those three buttons are when the
workbook is protected or when the title bar is just not visible.

You said no to both.

I don't have any other guesses. Maybe someone else can jump in.

kr4d wrote:

Thank you for the reply but this did not solve the issue! there is still no
minimize or maximize or exit button for the workbook?

"Dave Peterson" wrote:

Maybe the title bar is just off the visible screen.

Window|Arrange|Tiled
(and resize the way you like it)

kr4d wrote:

Thank you for the response, unfortunately the spreadsheet is not protected!

"Gord Dibben" wrote:

Sounds like the workbook protection is enabled.

ToolsProtectionUnProtect Workbook.

You may have to supply a password.


Gord Dibben Excel MVP

On Tue, 14 Jun 2005 09:15:01 -0700, "KR4d"
wrote:

I opened an excel spreadshhet which didnt contain the minimize, maximize and
exit button? now all my sheets are like that the only way to close a sheet
is to select file close? the buttons are on the main bar? please help



--

Dave Peterson


--

Dave Peterson