by Spike » Wed Jun 30, 2010 11:37 am
I've been transforming my excel sheets into COM based sheets- and so far it's all going pretty well despite my limited skills.
Just one thing though, I'd like to use .tabindex = 1 on one of my sheets so that I can follow different events simultaneously in different tabs (and on different sheets), but I can't quite figure out where to put it.
To get myself started I used the test_BA_com sheet as a framework so I have the same Worksheet_Activate and Start button code, I imagine it goes somewhere in there but I'd appreciate a pointer if anyone has a moment.
Thanks,
Michael