Click to See Complete Forum and Search --> : Excel Worksheet Window Problems
Spooky88
February 13th, 2004, 11:21 AM
When I open a specific worksheet in Excel 2000, I cannot resize the window. Part of the left side is off the screen. Tried looking in MS Knowledge Base but could not find an answer (may have been using the wrong keywords.)
Attached is a pic of the worksheet. Any help is appreciated.
WhitPhil
February 13th, 2004, 12:52 PM
What happens if you double click on the blue bar just above your spreadsheet data?
Spooky88
February 13th, 2004, 02:31 PM
Originally posted by WhitPhil
What happens if you double click on the blue bar just above your spreadsheet data?
Nothing happens. I don't even have the min/max buttons available.
John Steven
February 13th, 2004, 04:33 PM
Hi Spooky88,
From Spooky88
Nothing happens. I don't even have the min/max buttons available.
From Excel Help Files:
I can't maximize or close the workbook window.
The Maximize and Close buttons do not appear on windows that have been protected.
To remove protection, point to Protection on the Tools menu, and then click Unprotect Workbook. If prompted, enter the password. (If you are prompted for a password and you do not know the password, you cannot remove protection.)
To protect a workbook without protecting the windows, you can limit changes to an entire workbook without selecting window protection.
Hope this helps.........
Spooky88
February 13th, 2004, 10:40 PM
That is what the problem is. They (unknown) password protected the sheet. Thanks for the input :)