P
Phil Hageman
This sub is suppose run when the user closes the workbook -
it does not work. The two Auto_Close instructions are
reversals of instructions executed in "Sub Auto_Open()",
which run successfully when the workbook is opened. Both
instructions execute properly.
The expectation: when the user closes the workbook by
clicking on the "X" button, the screen display restores
the toolbars, and workbook tabs become visible.
Sub Auto_Close()
Application.DisplayFullScreen = True
Application.DisplayWorkbookTabs = True
End Sub
Can someone help make this Sub work correctly?
Thanks, Phil
it does not work. The two Auto_Close instructions are
reversals of instructions executed in "Sub Auto_Open()",
which run successfully when the workbook is opened. Both
instructions execute properly.
The expectation: when the user closes the workbook by
clicking on the "X" button, the screen display restores
the toolbars, and workbook tabs become visible.
Sub Auto_Close()
Application.DisplayFullScreen = True
Application.DisplayWorkbookTabs = True
End Sub
Can someone help make this Sub work correctly?
Thanks, Phil