Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Starting Auto_Close macro based on an IF statement | Excel Discussion (Misc queries) | |||
Auto_Close | Excel Programming |