Message boxes

Hi Mathew

Thanks for your question. You need to write the code in the on open event of the workbook.

Open the VBE and look at the project explorer. Double click on the ThisWorkbook icon.

Now in the code window click on the object combo box. (At the top left of the code window; it will probably initially have the value "General")

Select Workbook. This will create an on open sub procedure for the workbook. You can then enter your code here.

Regards

Stephen