It can't be done in the method you mentioned. What you can do is have excel
send an e-mail when the macro is run.

Sub SEND_MACRO_MAIL()
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String

Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)

strbody = "THE MACRO HAS BEEN RUN!!"

On Error Resume Next
With OutMail
.To = "
.CC = ""
.BCC = ""
.Subject = "THE MACRO HAS BEEN RUN!!"
.Body = strbody
.Send 'or use .Display
End With
On Error GoTo 0

Set OutMail = Nothing
Set OutApp = Nothing
End Sub





" wrote:

On a network of computers, is there any way to alert any of the other
computers when one computer runs a macro? I want to push a button on one
computer and run a macro. When this is done, I want a user on a separate
computer to know it's finished. THe best case would be if something could
appear on the other users screen, but I'm open to other ideas. I was also
thinking if the computer running the macro could make a sound of some sort to
alert the other users that it is finished.

Thanks and any input would be appreciated,

Adam Bush