mikechambers
Active Member
- Joined
- Apr 27, 2006
- Messages
- 397
I want to design something in Excel that would allow me to switch back and forth between tabs, similar to how you can switch back and forth between applications using Alt-Tab. What I can't figure out is how to have the code write the selected sheet name to a variable as soon as the tab is selected. So I think you would have two variables. When you click on a different tab, it writes the sheet name to var1. When you click on another tab, it writes to var2. When you press the hot key to run the code, it goes back to var 1. And the hot key would just keep going back and forth between the two most recent tabs. Think it's possible?