seniorjerry
New Member
- Joined
- Jan 20, 2023
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
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?
VBA Code:
Sub Summ()
Sheets("Summary").Activate
Sheets("Summary").Range("A1").Activate
End Sub