Is there a way of diplaying a message while an excel spreadsheet is opening?
Posted by Andrew on August 23, 2001 9:42 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?
I tried this code but it only displays once the spreadsheet has opened fully.
Private Sub Workbook_open()
MsgBox "Message", vbOKOnly + vbInformation, "Message Header"