View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ltong ltong is offline
external usenet poster
 
Posts: 22
Default Disable Message Prompt in VBA

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