LinkBack URL
About LinkBacks
Does anyone have an Excel macro that can alternate between worksheets in the same way Ctrl Tab alternates between workbooks?
Thanks so much,
Josh
Does anyone have an Excel macro that can alternate between worksheets in the same way Ctrl Tab alternates between workbooks?
Thanks so much,
Josh
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Sorry I made a mistake. I meant as in how to alternate between two worksheets you are looking at. Equivalent to Ctrl Tab, followed by Ctrl Shift Tab, Followed by Ctrl Tab again, does that make sense? Sorry I was stupid before!
Josh
I can envision this only with two separate macros.
Please Login or Register to view this content.Set each with a different short cut keyPlease Login or Register to view this content.
No that still doesn't work unfortunately. It just does the same as ctrl page up and ctrl page down. I need to skip all the worksheets inbetween because I have around 20 worksheets in workbooks and it is time consuming to move between all over them. Thanks,
If you know the sheet names - you could put this code in the ThisWorkbook module:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks