HELP ME Wierd display, can't change sheet

I don't know what I've done, but I want it to go back to normal
spreadsheet.jpg

Just double click on the title bar or click on the box on the top right (between the _ and the x)


Regards, TMS

Looks to me that you have clicked on the "restore" button - between the - and the X button. If you cant see the small square to click to restore, click on the bar where it shows the file name, and drag it to the left until you can see those buttons

No. Just double click on the title bar in the "bubble".


Regards, TMS

Try: View | Arrange All | Tiled. Then click on the maximise icon (between the minimise (_) and close (x))


Regards, TMS

I suspect that you have unintentionally clicked on the Restore down icon (the box) and then dragged the workbook "bubble" off screen to the right so that the icons are not visible. If that's the case, Click on the "inner" title bar and drag to the left till you see the icons. Then click on the Maximise icon (the box).

Are you actually trying the things that have been suggested? gpato's Ctrl-F10 worked for me. But then I'm controlling restoring and maximising the window myself.

Regards, TMS

upload your file here...as long as it doesnt contain sensitive data
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

@FDibbins: I did think of asking for a sample file, but surely it will be a local display issue? If Excel is set, locally, to open with the workbook pane maximised, that's what you'll get.


Regards, TMS

Probably so, Trevor But we have tried almost everything else, so I asked for the file to look at - else we will just keep guessing?

Regards
Ford

Yes, that's fair comment.

MY VBA is poor, but I have a feeling the macro you have in that file is doing that...Trevor?

No, I don't think so. It's just a page setup macro. And it's not called automatically anywhere.

Totally bemused.

However, please see the "new" version attached.

Regards, TMS

Yeah has me stumped as well...had to close ALL other open W/B's before it would let me close this 1. What did you do, copy/paste to a new W/B?

Picked up the sheet names in the VBE and then used:

Please Login or Register  to view this content.

to copy to a new workbook. Then copied the code module.

Regards, TMS

No, I have not fixed it. I just copied all the sheets and the code module to a new workbook. I still have no idea what you have done or how to fix it.

I have asked for others to have a look at it in the Water Cooler forum


Regards, TMS

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

the workbook is protected so you can't change the windows

I was able to open it without any problem, and can edit all cells. In fact I deleted everything on every sheet - as a test - and had no problems either?

it's the workbook windows that are protected not the sheets (and not the file-open protection). see the protect workbook option on the review tab

aahh ok, told you my VBA sucks lol

no vba involved in this

so.........??

My first impression of this problem was that the monitor did not fully refresh. If your computer has an AMD graphics adapter that allows you to over-clock the GPU and you have over-clocked, you can get incomplete screen refreshes if the conditions are just right....like a lot of formatting in your worksheet for example. If that is the case, just adjust the over-clocking back a bit. I haven't had this happen in Excel but did a couple of times with a graphics program.

I hope your worksheet "stays fixed".

Good luck.

press the protect workbook button on the review tab then enter the password (trusting the op knows this) and press ok. the workbook windows will now be back to normal-this not a problem or bug but normal behavior :-)

yup I approved to that JP. The OP protected the window.

@JP: yes, I cracked the password and keyed it in. You were/are absolutely correct, as ever.

Must admit, I've never seen that sort of effect before. I'll know for the future

Regards, TMS

You need to know that, not us ... well, not now. Follow JP's instructions and you should get your original workbook back. And you have the version that I provided that does not have workbook structure protection.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.