Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Title Bar minimize, maximize & close icons not present
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Title Bar minimize, maximize & close icons not present
P.S. View / Full Screen doesn't help.
-- Charlie "Charlie Shaw" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Title Bar minimize, maximize & close icons not present
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 wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Title Bar minimize, maximize & close icons not present
That did it Dave - Thanks.
I feel like a complete idiot - I should have seen that. -- Charlie "Dave Peterson" wrote: 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 wrote: 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 -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Title Bar minimize, maximize & close icons not present
Sometimes, it just takes that extra pair of eyes.
Charlie Shaw wrote: That did it Dave - Thanks. I feel like a complete idiot - I should have seen that. -- Charlie "Dave Peterson" wrote: 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 wrote: 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 -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Title Bar minimize, maximize & close icons not present
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. -- Charlie "Dave Peterson" wrote: Sometimes, it just takes that extra pair of eyes. Charlie Shaw wrote: That did it Dave - Thanks. I feel like a complete idiot - I should have seen that. -- Charlie "Dave Peterson" wrote: 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 wrote: 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 -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Title Bar minimize, maximize & close icons not present
Even though OP stated the workbook and worksheet are not protected
The workbook and worksheets are not protected Dave strikes again with the unerring accuracy of a psychic drawing to an inside straight. Gord On Sat, 19 May 2007 16:19:50 -0500, Dave Peterson wrote: Sometimes, it just takes that extra pair of eyes. Charlie Shaw wrote: That did it Dave - Thanks. I feel like a complete idiot - I should have seen that. -- Charlie "Dave Peterson" wrote: 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 wrote: 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 -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Title Bar minimize, maximize & close icons not present
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 wrote: Even though OP stated the workbook and worksheet are not protected The workbook and worksheets are not protected Dave strikes again with the unerring accuracy of a psychic drawing to an inside straight. Gord On Sat, 19 May 2007 16:19:50 -0500, Dave Peterson wrote: Sometimes, it just takes that extra pair of eyes. Charlie Shaw wrote: That did it Dave - Thanks. I feel like a complete idiot - I should have seen that. -- Charlie "Dave Peterson" wrote: 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 wrote: 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 -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Title Bar minimize, maximize & close icons not present
I agree.
Many users believe workbook protection is only "password to open file" protection and miss the ToolsProtectionProtect Workbook feature. Seems many know about worksheet protection which is on the same Menu. Gord On Sat, 19 May 2007 19:50:51 -0500, Dave Peterson wrote: 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 wrote: Even though OP stated the workbook and worksheet are not protected The workbook and worksheets are not protected Dave strikes again with the unerring accuracy of a psychic drawing to an inside straight. Gord On Sat, 19 May 2007 16:19:50 -0500, Dave Peterson wrote: Sometimes, it just takes that extra pair of eyes. Charlie Shaw wrote: That did it Dave - Thanks. I feel like a complete idiot - I should have seen that. -- Charlie "Dave Peterson" wrote: 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 wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
minimize and maximize buttons missing | Excel Discussion (Misc queries) | |||
restore title bar icons | Excel Discussion (Misc queries) | |||
Why doesn't my resized worksheet have a minimize or close box in . | Excel Worksheet Functions | |||
excel 'lost my title bar with min. restore down, close buttons' | Excel Discussion (Misc queries) | |||
how do i minimize/maximize a workbook from vba? I want to minimize it durring processing to speed things up a bit | Excel Worksheet Functions |