VBA Change Active Windows active sheet

[seniorjerry]

I have a very simple macro tied to Ctrl + Shift + A which bring you to a certain sheet. However if I have multiple windows open it can act weirdly. On my laptop it changes the active window to that sheet but on my desktop it changes window 1 to that sheet and not the active window. Is their a way to only change the sheet of the active window or is their maybe a setting that I am missing that is making this inconsistency happen?

Sub Summ()
    Sheets("Summary").Activate
    Sheets("Summary").Range("A1").Activate
End Sub

 

[Skyybot]

If you have multiple Workbooks open, you might need to specify the Workbook. Try this:

Sub Summ()
    Workbooks("YourWorkbookName").Sheets("Summary").Activate
    Workbooks("YourWorkbookName").Sheets("Summary").Range("A1").Activate
End Sub

 

[seniorjerry]

If you have multiple Workbooks open, you might need to specify the Workbook. Try this:

Sub Summ()
    Workbooks("YourWorkbookName").Sheets("Summary").Activate
    Workbooks("YourWorkbookName").Sheets("Summary").Range("A1").Activate
End Sub

This doesn't seem to fix it tried ThisWorkbook. & Workbooks(ActiveWorkbook.Name). and neither seemed to work for this any other ideas on this problem?

 

[Skyybot]

Try using the actual name of the Workbook. i.e. - Workbooks("MyExcelFile.xlsm").Sheets("Summary").Activate