View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Edwin Tam (MS MVP) Edwin Tam (MS MVP) is offline
external usenet poster
 
Posts: 48
Default 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