ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I have a workbook that wont maximise or resize when opened (https://www.excelbanter.com/excel-discussion-misc-queries/43835-i-have-workbook-wont-maximise-resize-when-opened.html)

Chris H

I have a workbook that wont maximise or resize when opened
 
I have a workbook that used to fill the screen when opened. Now when I open
it, it appears in a small window and I cant resize or maximise it as all the
standard buttons on this small window have disappeared!!! Please help!

Dave Peterson

It sounds like the workbook is protected.

Try Tools|protection.
Do you see Unprotect Workbook?

If yes, click on that (you may need a password to unprotect it, though).

If this works, it was caused by:

Tools|protection|protect workbook
and someone checked that Windows option.

Chris H wrote:

I have a workbook that used to fill the screen when opened. Now when I open
it, it appears in a small window and I cant resize or maximise it as all the
standard buttons on this small window have disappeared!!! Please help!


--

Dave Peterson


All times are GMT +1. The time now is 02:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com