Created a macro to define a variable for the current activated workbook. Then I open another file. And then I want to activate the first workbook. The code defaults when cworkbook is asked to be activated in the end of the code:
Sub This_Workbook()
'Reference to active work book
Dim cWorkbook As Workbook
Set cWorkbook = activeworkbook
Debug.Print cWorkbook.Name
Workbooks.Open ("S:\TB\UK TB_MTD_0918-en-us.xlsx")
Workbooks(cWorkbook).Activate
End Sub
Sub This_Workbook()
'Reference to active work book
Dim cWorkbook As Workbook
Set cWorkbook = activeworkbook
Debug.Print cWorkbook.Name
Workbooks.Open ("S:\TB\UK TB_MTD_0918-en-us.xlsx")
Workbooks(cWorkbook).Activate
End Sub