I am trying to write a macro that will run each time I open a particular
workbook. The macro has been written, tested and stored in the workbook but I
cannot find out how to run it when I open the workbook.

I would also like to perform a Save As of this workbook if the workbook name
equals MyWorkbook but allow a regular save if the name does not equal
MyWorkbook.

Thanks, I appreciate the help!