Hello - I have a database that generally has a master workbook (Operations) open at all time. A series of smaller workbooks (Tasks 001-025, Tasks 026-051, etc) are opened to correspond with the master as data is entered. Typically only two workbooks are open at a time. When I close the Tasks workbook the Operations workbook reverts to a xlMaximized size.

Is there some piece of code that will keep it at xlNormal when the Task workbooks close?

Here is the code I have which doesn't seem to do it:

Private Sub Workbook_BeforeClose(Cancel As Boolean)

Application.CommandBars("Ply").Enabled = True
Application.DisplayFullScreen = False
Application.WindowState = xlMaximized

End Sub

If I change Application.WindowState = xlNormal it makes the Operations workbook completely shrunk on the screen to the point of needing to re-size it.

Any suggestions would be apreciated