ALERT Pop up Box

[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

 

[Dave Peterson]

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

 

[mellowe]

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?

 

[Dave Peterson]

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?

 

[mellowe]

oh well thanks anyway... my search continues!