What is the message prompt?

I would suggest you don't name your macro Run since that the name of a built
in procedure - which you are well aware of.

--
Regards,
Tom Ogilvy

"ltong" wrote in message
om...
Hi,

How to disable the message prompt when running a Run macro ?

Below is the example of VBA code for

a)Run macro

Sub Run()
Application.Run "BOT.bankrecon.XLS!Module14.BOT"
End Sub

b)BOT macro

Sub BOT()
Dim Macro1 As String
Range("A12").Select

If Range("A12") = "Done" Then
Macro1 = x
x = False

Else
MsgBox "Please click Once", vbInformation, "Msg Box vbInformation"

Range("A12").Select
Range("A12") = "Done"
End If
End Sub

Please help
Thanks

Regards
Lenard