VBA

Hi Edward

To run a macro when the workbook opens you need to do the following:

1. In the VB Editor double click "This Workbook" in the project window

2. The code window for "This Workbook" appears

3. In the drop down area at the top select Workbook. The Open Event Procedure appears.

4. Call the macro as shown below:

Private Sub Workbook_Open()

Call MyMacro

End Sub

Hope this helps

Carlos