Option Explicit
Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _
(ByVal hWnd As Long, ByVal lpOperation As String, ByVal lpfile As String, _
ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
'Callback for btLance01 onAction
Sub bt01(control As IRibbonControl)
Workbooks.Open Filename:="****"
Application.Run "***!Macro1"
End Sub
Sub bt02(control As IRibbonControl)
Workbooks.Open Filename:="***"
Application.Run "***!Macro1"
End Sub
Sub bt03(control As IRibbonControl)
Workbooks.Open Filename:="***"
Application.Run "***!BCAPETR"
End Sub
Sub bt04(control As IRibbonControl)
Workbooks.Open Filename:="***"
Application.Run "***!BCAPFR"
End Sub
Sub bt05(control As IRibbonControl)
Workbooks.Open Filename:="***!CCBP"
End Sub