MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

Posted by Andrew on August 21, 2001 9:35 PM

I have an excel spreadsheet that takes +- 2 minutes to fully open as a result of updating thousands of links. Is there a way to display a message while it is opening so that the users do not think it has crashed?

Posted by M Walker on August 22, 2001 2:08 AM

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.


Posted by Andrew on August 22, 2001 11:49 AM

Thanks !!!

Works great - thanks