Auto_Close() needs help
The problem is with this line
Application.DisplayWorkbookTabs = Tru
It should be
ActiveWindow.DisplayWorkbookTabs = Tru
Try again
----- Phil Hageman wrote: ----
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 = Tru
Application.DisplayWorkbookTabs = Tru
End Su
Can someone help make this Sub work correctly
Thanks, Phi
|