Neil

Place it in the ThisWorkbook module like so.........

Private Sub Workbook_Open()

your code or macroname goes here

End Sub

Right-click on the Excel logo left of "File" on menu bar or on logo at top
left corner of Window if not maximized.

Select "View Code" to open the module.

Gord Dibben Excel MVP

Or you can leave it in a General module and call it Auto_open().