Auto Macro

Posted by M. Sanders on August 07, 2001 7:11 AM

I want a macro to run every time a workbook is opened. In VB I am trying to use the following.

Sub Workbook_Open()
Application.Goto Reference:="Print_Titles"
ActiveWindow.Zoom = True
End Sub

If I run the macro is works, but it does not run automatically when the workbook is opened.

Can someone help?

Thanks

Posted by Dax on August 07, 2001 7:55 AM

You have to call the subroutine Auto_Open. Alternatively, you can double click the ThisWorkbook icon in the Project Explorer and then use the Workbook_Open procedure.

Regards,
Dax.