Continue macro from current workbook
 

Hi,

I'm looking for vba codes to continue running the macro from workbook1
to workbook2 after furnishing data form in workbook2 and continue
macro in workbook1

Extract codes below

Workbook1
Windows("Workbook1").Activate
Dim Frm As Object
Dim varAnswer As String
varAnswer = MsgBox("Do you want to update worksheet name ?",
vbYesNo, "OpenWorksheetNameForm")
If varAnswer = vbYes Then
Set Frm = Application.Run("'" & ActiveWorkbook.Name & "'!
OpenWorksheetNameForm")
Frm.Show
End If
If varAnswer = vbNo Then
GoTo NextSelection
End If

Workbook2
Sub OpenWorksheetNameForm()
frmWorksheetName.Show
End Sub

Any helps will be appreciated and thanks in advance

Regards
Len