Hi I am using the following code to open another workbook and it works great. However I was wondering how it could be adapted so that when it opens the workbook it also makes the newly open workbook the current active workbook on screen.
At the moment it opens but I remain on my current workbook.
I would be grateful for any help.
At the moment it opens but I remain on my current workbook.
Code:
Sub Finance_Overview()
Application.ScreenUpdating = False
Workbooks.Open Filename:="D:\Finance\Finance Overview.xlsm"
ThisWorkbook.Activate
Application.ScreenUpdating = True
End Sub
I would be grateful for any help.