A:Don't quite understand the second part but to run a messagebox on opening the file right click on a sheet tab and click on View Code. On the VBA screen that appears click on ThisWorkbook in the Project box. In the dropdown that says (General) select Workbook and you should get text. Enter below..
Private Sub Workbook_Open ()
Msgbox "yourtext"
End Sub
