Title Bar minimize, maximize & close icons not present

C

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

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

Charlie Shaw

That did it Dave - Thanks.

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

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

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
 
D

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

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
 

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