Hi John,

Sub Workbook_Close()

There is no Workbook_Close event. This should be:

Private Sub Workbook_BeforeClose(Cancel As Boolean)

What is your purpose in calling the ealier Auto_Open and Auto_Close instead
of simply using the Workbook_Open and Workbook_beforeClose events?


---
Regards,
Norman



"John Keith" wrote in message
...
thought i found the error of my ways.. But
Sub Workbook_Open()
Stop
Auto_Open
End Sub
Sub Workbook_Close()
Stop
Auto_Close
End Sub
Doesn't work either...
--
Regards,
John


"John Keith" wrote:

I have a sheet originally developed with Excel2002 using the Auto_Open
routine.
I then found that I needed to make this project work with the older
version.

why wont this work?
*** in ThisWorkbook's module ***
Sub Worksheet_Open()
Stop 'for test
Auto_Open
End Sub
Sub WorkSheet_Close()
Stop 'for test
Auto_Close
End Sub

*** in a standard module ***
Public Sub Auto_Open()
...

Public Sus Auto_Close()
...

I have put "stops" in the code to verify that the routines are never
getting
control.
I am forced to first open Excel2000 then load the sheet because excel2002
is
the version that is auto launched on dbl-click of a XLS file. (and the
Auto_'s work perfectly in that version.)



--
Regards,
John