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
Bookmarks