I'm working with a workbook which has got 11 worksheets. I have frequently switch between worksheets. Mostly I work between different pairs of worksheets. If I use the mouse, sometimes I have to scroll left or right to find the worksheet that I to switch to.
I was hoping that there would be some kind of a keyboard shortcut like "control + tab" available in Microsoft Excel. But I could not find anything. I also looked at the meditation but surprisingly I was not able to find anything. To me, this should be a common problem and I was hoping there would be a solution out there. Even if it is in terms of using a macro, that is also acceptable.
Thank you for any inputs
Workbook_BeforeClose
that resets a cell to itself and saves, so the current worksheet is always the last-updated when closing and will be the current on opening.