Magic Sheet Wrapping

Question

Hello, 
 
 I have a macro on my xkeys that I love very much, which types"Magic Sheet Next Enter" 
 
 My only sadness is that it doesn't wrap from the last magic sheet to the first. Does anyone have any recommendations to get this one button to cycle through the magic sheets the way i'd like? 
 
 Thanks, Nick

John728 · Accepted Answer

Program your xkeys button to: 
 
 m 9 enter 
 
 Macro x is MS x enter macro (x+1) copy to 9 enter enter, e.g.: 
 
 Record macro 1 as: 
 
 Magic_Sheet 1 enter macro 2 copy_to 9 enter enter 
 
 Record macro 2 as: 
 
 Magic_Sheet 2 enter macro 3 copy_to 9 enter enter 
 
 The macro for the last MS is MS y enter macro 1 copy to 9 enter enter, e.g: 
 
 Magic_Sheet 3 enter macro 1 copy_to 9 enter enter 
 
 Set all of them to background mode to preserve your command line while running them. Run macro 1 from the command line to create macro 9. Now every time you hit the button, it cycles through the magic sheets.