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

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

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

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

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

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