Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am attaching a graphic of a problem I am having with a workbook that I have helped a gentlemen with several times over. This time I do not know what he has done, and find it laughable that I can't figure this one out.

    1. The workbook window has been made very small (It is a rather large workbook)
    2. It is not password protected in any way
    3. The check boxes for everything to be visible are on (formula bar, scroll bars, headings etc...)
    4. Restore does nothing (and I only have access to the Excel Window itself anyway, not the control box for the workbook)
    5. There are no resizing handles that appear in any portion of the workbook to stretch it back out.
    6. I can't get my hands on the title bar to drag it back out even after minimizing the ribbon etc...
    7. Full screen doesn't help, (nor any other view I've tried)
    8. Tiling the windows doesn't help (to try and get the title bar)
    9. What detail is that I can only scroll to column D on the left side of the worksheet. Trying to unhide A-C but can't.
    I'm insane looking at this spreadsheet. Any clues or keyboard shortcuts to get my hands on the title bar OR to get the sizing arrows around the window.
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by teachesms View Post
    I am attaching a graphic of a problem I am having with a workbook that I have helped a gentlemen with several times over. This time I do not know what he has done, and find it laughable that I can't figure this one out.

    1. The workbook window has been made very small (It is a rather large workbook)
    2. It is not password protected in any way
    3. The check boxes for everything to be visible are on (formula bar, scroll bars, headings etc...)
    4. Restore does nothing (and I only have access to the Excel Window itself anyway, not the control box for the workbook)
    5. There are no resizing handles that appear in any portion of the workbook to stretch it back out.
    6. I can't get my hands on the title bar to drag it back out even after minimizing the ribbon etc...
    7. Full screen doesn't help, (nor any other view I've tried)
    8. Tiling the windows doesn't help (to try and get the title bar)
    9. What detail is that I can only scroll to column D on the left side of the worksheet. Trying to unhide A-C but can't.
    I'm insane looking at this spreadsheet. Any clues or keyboard shortcuts to get my hands on the title bar OR to get the sizing arrows around the window.
    Did you check to see if there are macros in the workbook?
    Chuck Reimer
    I'm from the Government and I'm here to help...

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I don't see a graphic. Could you post a copy of the workbook?

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by HansV View Post
    I don't see a graphic. Could you post a copy of the workbook?
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts
    It is over 2 mg
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Try the following:

    • Press Ctrl+F7 to enter Move mode.
    • Use the arrow keys on the keyboard to move the window around until you see the title bar, minimize/maximize buttons etc.
    • Press Enter to exit Move mode and leave the window in the new position.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    If you unprotect the workbook, you'll be able to move its window, resize it etc.
    To do this:

    • Activate the Review tab of the ribbon.
    • In the Changes section, click Unprotect Workbook


    That's it!


  8. #8
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by HansV View Post
    If you unprotect the workbook, you'll be able to move its window, resize it etc.
    To do this:

    • Activate the Review tab of the ribbon.
    • In the Changes section, click Unprotect Workbook


    That's it!

    I was working with the protect sheet ensuring it wasn't protected...didn't notice that the workbook was protected as I expected a password box to appear and because there was no password, did not notice that it "was" in fact protected. Gosh I hate days like this.

    Thank you Hans...and believe it or not...I figured that out after screwing around with it here for a little...but thank you as you found the same result nearly at the same time as I did.
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •