Is there a way of diplaying a message while an excel spreadsheet is opening?

If you go into the VBA editor (off the macro option in the tools menu in excel) you can see the workbook structure on the left hand side. If you view the code for ThisWorkbook and use a code like this ;

Private Sub Workbook_open()
MsgBox "The workbook may take up to 2 minutes to open. Please be patient. Thanks.", vbOKOnly + vbInformation, "Please take note..."
End Sub

WHoever opens the workbook will see the messeage box and have to click on the ok button. Simply change the text in "" to suit your needs. The "please take note..." appears as the messeage box header.

Hope this helps.
If not email me back.

Matt

Thanks !!!

Works great - thanks