Title Bar minimize, maximize & close icons not present

[Charlie Shaw]

The title bar minimize, maximize & close icons are not present in a
spreadsheet that was emailed to me. The file name shows in the title bar
(compatability mode), and the workbook is in the "restore down" window state
and cannot be moved (dragged) in the Excel workspace. The workbook and
worksheets are not protected. I am using Excel 2007.

When I create a new workbook, I do not have this problem, and the title bar
menu icons display appropriately. This is more an annoyance than anything,
but I would appreciate any suggestions about how to resolve this issue.
Thanks.

 

[Charlie Shaw]

P.S. View / Full Screen doesn't help.

 

[Dave Peterson]

Any chance that your workbook is protected (with Windows checked).

On the Review tab, try clicking on Protect Workbook.

Is "Protect Structure and windows" checked?

If yes, then uncheck it. You may need to supply a password.

 

[Charlie Shaw]

That did it Dave - Thanks.

I feel like a complete idiot - I should have seen that.

 

[Dave Peterson]

Sometimes, it just takes that extra pair of eyes.

That did it Dave - Thanks.

I feel like a complete idiot - I should have seen that.

 

[Charlie Shaw]

Yep, either that or backing off from the issue, and then doing a relook a
coouple of hours later with your own set of refreshed eyes.

 

[Gord Dibben]

Even though OP stated the workbook and worksheet are not protected

Dave strikes again with the unerring accuracy of a psychic drawing to an inside
straight.


Gord

 

[Dave Peterson]

Did you misspell psycho? <vbg>

But lots of times, it helps when you don't read the whole message--and just
provide an answer to a different question????

I wonder if the OP meant that the workbook wasn't protected via
file|saveas|tools|general options (password to open). It can come as a surprise
at how many different "levels" of protection there can be in an excel workbook.

 

[Gord Dibben]

I agree.

Many users believe workbook protection is only "password to open file"
protection and miss the Tools>Protection>Protect Workbook feature.

Seems many know about worksheet protection which is on the same Menu.


Gord