Why doesn't my resized worksheet have a minimize or close box in .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The specific workbook opens each worksheet as a resized window about 95% of
screen with no minimize, resize, or close box in the top blue title bar of
the worksheet. One worksheet Columns A and B appear hidden or off screen
with a windows split pane. They cannot be restored (not even with the format
column unhide executed from the worksheet global box selected using
format/columns/ unhide. The windows split and unfreeze options are grayed
out.
 
The Workbook windows are protected.

To unprotect them (you may need a password):
Choose Tools>Protections>Unprotect workbook
 
Thought that also, but the worksheet does not appear to be protected.
Although another user tried to protect the worksheet at one point, her
password will not unprotect it. I can also enter in any cell and when I
choose "Tools>Protection" I see the both the "unprotect" and the "protect"
options are available, making me believe it is not protected and the problem
is more than a "forgotten password".

More ideas?
Thanks,
 
The worksheet may be unprotected, but the workBOOK is protected.
They're two separate commands on the Tools>Protection menu.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top