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

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.
 
D

Debra Dalgleish

The Workbook windows are protected.

To unprotect them (you may need a password):
Choose Tools>Protections>Unprotect workbook
 
G

Guest

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,
 
D

Debra Dalgleish

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

Top