It is not workbookOpen(), but Workbook_Open()

Private Sub Workbook_Open()

Also, this code should be in the This workbook portion of your VBA - Right
click on the Excell icon in the upper left-hand corner of the screen, select
View Code and insert there.

"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