Inner window frozen

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BobB - 03 Dec 2007 00:08 GMT

I used to be able to move the spreadsheet within the overall Excel window.
Somehow I have lost this ability and the spreadsheet is now fixed. There
use to be a blue title bar that I could use to move the spreadsheet around.
What did I do? and how do I undo it?

Bob

Reply to this Message

Gord Dibben - 03 Dec 2007 00:59 GMT

Click on the "Restore" Icon.

Sounds like you have the window maximized.

Gord Dibben MS Excel MVP

>I used to be able to move the spreadsheet within the overall Excel window.
>Somehow I have lost this ability and the spreadsheet is now fixed. There
>use to be a blue title bar that I could use to move the spreadsheet around.
>What did I do? and how do I undo it?
>
>Bob

Reply to this Message

BobB - 03 Dec 2007 22:18 GMT

Excuse my ignorance, but what is the "Restore Icon"?

> Click on the "Restore" Icon.
>
[quoted text clipped - 9 lines]
>>
>>Bob

Reply to this Message

Gord Dibben - 03 Dec 2007 22:47 GMT

If Excel and the workbook windows are maximized.............

At top right of window you will have 3 icons on each of two bars.

A minis sign for minimizing, a double box for restoring or a single box for
maximizing and an "x" for closing

Click on the lower of the two double boxes to restore the workbook window.

Gord

>Excuse my ignorance, but what is the "Restore Icon"?
>
[quoted text clipped - 11 lines]
>>>
>>>Bob

Reply to this Message

craig Turner - 27 Oct 2008 06:15 GMT

Bob,

Your workbook is Protected.

Go to "review"

"unprotect workbook"

Then you should be sweet

Have a good one

Reply to this Message

ShaneDevenshire - 27 Oct 2008 15:20 GMT

Hi,

This question is not clear, however, assuming you have a sheet protection
problem, if you are using 2003 or earlier, choose Tools, Protection,
Unprotect Worksheet. If you need a password I can't help.

Signature

Thanks,
Shane Devenshire

"unknown" wrote:

Reply to this Message