Workbook is stuck in minimized view

[davidl]

Hello,

When I open one specific file in Excel, the workbook opens, but only in a small area of the window is seen (like it is minimized). However, there are no minimize/maximize/close buttons on the workbook outline; only on the main Excel page. The workbook window cannot be resized or moved. I'm trying to find a way to "unlock" it.

 

[Hui]

David


Welcome to the Chandoo.org forums


Select the Workbook

Goto VBA using Alt F11

Click in the Immediate Window, If it's not visible Ctrl G

Type (Copy & Paste) the following and press enter


ActiveWindow.WindowState = xlMaximized


Let us know if that helps ?

 

[davidl]

Hello Hui,


Thanks for your swift reply, I appreciate your help. Unfortunately, this did not work. I received a "Run-time error '1004': Unable to set the WindowState property of the window class". Right now, I'm trying to compare the Properties of this workbook (which is "stuck" minimized) to another workbook (which is not "stuck").


Regards

 

[Hui]

David


acn you try this please


Select the Workbook

Goto VBA using Alt F11

Click in the Immediate Window, If it's not visible Ctrl G

Type (Copy & Paste) the following and press enter


ActiveWindow.WindowState = xlNormal


Let us know what happens?


What version of Windows/Excel are you using ?

 

[davidl]

Hello Hui,


Thanks for your continued support! I tried the new command, but again no luck. I received the same "Run-time error '1004..." as before. I am using Excel version 2007.


Regards

 

[davidl]

Oh...and using Windows 7 OS.

 

[davidl]

Hello Hui,


I got the workbook to maximize. I was exploring the Protect Workbook section of the Review tab. I selected Protect Workbook & unselected Protect Structure and Windows. This opened up the workbook window.


Thanks again for your help! I truly appreciate your assistance.


Regards