Prevent user interrupting Macro ?

[JumboCactuar]

Hi,
i have a macro which depending on data size, can take up to 2 minutes to complete.

Now ive found if whilst this is running the user gets impatient and clicks the mouse / keyboard etc.. then i get "excel not responding"

--

Is there any way to prevent this? Was thinking maybe a userform box that pops up whilst its running and closes on finish but unsure how to integrate this

Thanks for any help

 

[Fluff]

You could put this at the start of the code

   UserForm1.Show vbModeless

and then this at the end

   Unload UserForm1

It won't stop idiots, but might deter some

 

[DanteAmor]

You can put your macro, maybe we can improve it a bit.