"don" wrote in message
...
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

As well as the other two replies so far, (and this might be obvious -
apologies if I'm teaching you to suck eggs) but have you (and all your users
if you're not the only user of this wkbk) enabled macros by setting an
appropriate security level via Tools | Macro | Security ?