How do I save the following in Thisworkbook object.
Looking thru help I only see Thisworkbook discussed as a property.

Thanks
Don


On Sun, 4 Jun 2006 02:34:07 -0500, Ivan F Moala
wrote:


don Wrote:
This routine does not start when the workbook is opened.
Does it have to be saved somewhere other than on a VBA module of the
workbook.


Private Sub WorkbookOpen()
Call MyMacro
End Sub

it needs to be save in the ThisWorkbook object and NOT a Std Module