Control User Focus during processing VBA

When a user clicks "go" to run my vba application, it is processing data for about 30 seconds, is there any way to have a box come up during that time that says like "processing" or something, a开发者_开发技巧nd not allow the user to click anywhere until it is done/goes away?

Thanks in advance, Joe

Have you tried displaying a message box, then disabling updating the screen and events until the process is over? The user would be able to close out the message box, but they would be unable to interact with the sheet while you are processing. It would like something like this:

MsgBox "Please wait until the process is complete. This may take some time."
Application.ScreenUpdating = False
Application.EnableEvents = False
'Your Code Here
Application.ScreenUpdating = True
Application.EnableEvents = True