danovkos
05-21-2010, 05:27 AM
Hi all,
Pls. i have a lot of sheets in my workbook. I try to figured out, how to do BACK function between sheets. I mean, when i am in sheet 2 and swtich to sheet 3 then i press e.g. key F6 and it swich back to sheet 2.
Is here any easy way, how to do it?
I think it can works something like. If sheets is changing (when i leave e.g. sheet "3" it will write name of this sheet to some existing sheet in wb(e.g. to sheet "data" in cell B1 - this can be always allocated for this function). And then any macro will look here and after pressing F6 it activate sheet from cell B1.
I use key mapping like this:
Application.OnKey "{TAB}", "GoToTextBox"
but i dont know how to do - after sheets leaving wrote name of sheet to B1...
thx a lot for help
Pls. i have a lot of sheets in my workbook. I try to figured out, how to do BACK function between sheets. I mean, when i am in sheet 2 and swtich to sheet 3 then i press e.g. key F6 and it swich back to sheet 2.
Is here any easy way, how to do it?
I think it can works something like. If sheets is changing (when i leave e.g. sheet "3" it will write name of this sheet to some existing sheet in wb(e.g. to sheet "data" in cell B1 - this can be always allocated for this function). And then any macro will look here and after pressing F6 it activate sheet from cell B1.
I use key mapping like this:
Application.OnKey "{TAB}", "GoToTextBox"
but i dont know how to do - after sheets leaving wrote name of sheet to B1...
thx a lot for help