Hi,
I would start with the usual suspects: Close and open the workbook. Close and reload Excel. Restart the computer. Run a virus scan! If all of these fail, either your worksheet is corrupt or there is some code in it that sets the WindowState. So, you might try fighting water with water. Open the VB Editor Window (Alt_F11). Open the Immediate Window if it isn't shown already (View/Immediate Window). Put this code in the Immediate Window:
- Code: Select all
Application.WindowState = xlMaximized
Press Enter.
Coming to think of it, this probably won't work because it maximazes the Active Window. Your problem might be that you can't make your workbook the ActiveWindow. If this is the case the question is why you can't. Answer: Because something is preventing you from selecting it. This might be another file that is hugging the limelight. Or your Excel application software might be damanged. So, add "Repair Excel" to the list of suspects.
Basically, if the PC has been freshly started, and Excel has been freshly started, and there isn't any other workbook around, the workbook you open can't be minimized. If it still is you should see a blank screen with "Excel" in the window's caption and the workbook's tab in the Toolbar at the bottom. If that is what you see the above code might do its job. But it will not cure the problem and the workbook might be minimized again at any time.
I wish you luck - the good variety of it, and in adequate measure.
Have a pleasant evening!
Have a great day!
Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)