In that case, you should use this variation of the macro: You might not want the macro to do anything unless either Sheet1 or Sheet4 is displayed. This is handy, but it means that if you currently have Sheet2 displayed, the shortcut will always display Sheet1. In all other instances, Sheet1 is displayed. If it is Sheet1, then Sheet4 is displayed. The macro simply checks to see which worksheet is currently displayed. If you are looking for a single shortcut that will toggle between the two worksheets, then you can use a macro such as this: These would be easy enough to create using the macro recorder, and you could assign a shortcut key to each of the macros. One macro would jump to Sheet1 and the other to Sheet4. If desired, you could define two macros that would do the jumping. What if you want to use a shortcut to move between two specific, non-neighboring worksheets, such as Sheet1 and Sheet4? In this case, it is best to use a macro to do the jumping around. You can easily move between worksheets in a workbook by using Ctrl+Pg Up and Ctrl+Pg Down.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |