ALERT Pop up Box

  • Thread starter Thread starter mellowe
  • Start date Start date
M

mellowe

Hi All

I am running a macro that calculates and produces several workbooks for
a number of people. What I would like to do is have a pop up box appear
on each of their computers just before the macro is ran to ask them to
"Get out of their workbooks as the macro is about to be ran".

Is this possible? Thnkx
 
Maybe you can add something like this at the start of your code:

Dim Resp As Long

Resp = MsgBox(Prompt:="Is your workbook closed so the macro can continue", _
Buttons:=vbYesNo)

If Resp = vbNo Then
Exit Sub
End If
 
Thanks Dave for the response and this does work but only to whomever is
running the macro. Is there a way for me to run the macro from my
machine but have the message pop up on other's computers - so that they
can come out of the relevant workbooks so that my macro can run?
 
Ahhh. I see.

Not that I know.
Thanks Dave for the response and this does work but only to whomever is
running the macro. Is there a way for me to run the macro from my
machine but have the message pop up on other's computers - so that they
can come out of the relevant workbooks so that my macro can run?
Click to expand...
 
Back
Top