I have a command button with this code.
TST is a macro.
I need to add 2 other macro with this command button.
The names of the macro are:
Button2_Click
Save_Workbook
How do I do it?
Private Sub CommandButton2_Click()
TST
Dim path As String
Dim filename1 As String
Dim filename2 As String
path = "G:\Due\"
filename1 = Range("C3").Text
filename2 = Range("Q42").Text
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:=path & filename1 & "-" & filename2 & ".xlsx", FileFormat:=xlOpenXMLWorkbook, Password:="som"
Application.DisplayAlerts = True
When i add the macro name as TST the I get this error.
I have attached the screenshot of it.
Bookmarks