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
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.
Tools>Protection>UnProtect Workbook.
You may have to supply a password.
Gord Dibben Excel MVP
On Tue, 14 Jun 2005 09:15:01 -0700, "KR4d" <KR4d@discussions.microsoft.com>
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.
>
> Tools>Protection>UnProtect Workbook.
>
> You may have to supply a password.
>
>
> Gord Dibben Excel MVP
>
> On Tue, 14 Jun 2005 09:15:01 -0700, "KR4d" <KR4d@discussions.microsoft.com>
> 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.
> >
> > Tools>Protection>UnProtect Workbook.
> >
> > You may have to supply a password.
> >
> >
> > Gord Dibben Excel MVP
> >
> > On Tue, 14 Jun 2005 09:15:01 -0700, "KR4d" <KR4d@discussions.microsoft.com>
> > 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.
> > >
> > > Tools>Protection>UnProtect Workbook.
> > >
> > > You may have to supply a password.
> > >
> > >
> > > Gord Dibben Excel MVP
> > >
> > > On Tue, 14 Jun 2005 09:15:01 -0700, "KR4d" <KR4d@discussions.microsoft.com>
> > > 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.
> > > >
> > > > Tools>Protection>UnProtect Workbook.
> > > >
> > > > You may have to supply a password.
> > > >
> > > >
> > > > Gord Dibben Excel MVP
> > > >
> > > > On Tue, 14 Jun 2005 09:15:01 -0700, "KR4d" <KR4d@discussions.microsoft.com>
> > > > 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
Why this thread was set to [Solved], all replies seems take no effect...
Now I encounter same problem, can get no help from such [solved] thread.
bytec0des welcome to the forum
I guess it was closed because it was so old?
I suggest that you your own thread on this, and ask your question there![]()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks