Discussion
peter tdci said:
Sussed it from link, tks, and cheers guys, excellent result, 
In the olden days I would have suggested recording a simple macro and assigning it to a button drawn in the sheet .. but I'll be damned if I canf ind how you draw a button and assign a macro to it in the Office 2016.
ETA - found it .. need to display the "developer" toolbar.
My suggestion...
1. Record macro which just records you clicking on the tab you want and (optionally) moving to the first cell you are interested in
2. Add a Macro Button and assign the macro you just recorded.
ETA - found it .. need to display the "developer" toolbar.
My suggestion...
1. Record macro which just records you clicking on the tab you want and (optionally) moving to the first cell you are interested in
2. Add a Macro Button and assign the macro you just recorded.
Edited by sgrimshaw on Friday 2nd November 07:44
sgrimshaw said:
In the olden days I would have suggested recording a simple macro and assigning it to a button drawn in the sheet .. but I'll be damned if I canf ind how you draw a button and assign a macro to it in the Office 2016.
ETA - found it .. need to display the "developer" toolbar.
My suggestion...
1. Record macro which just records you clicking on the tab you want and (optionally) moving to the first cell you are interested in
2. Add a Macro Button and assign the macro you just recorded.
All sorted thanks, was moving between "SHEETS", so didnt need to use a macro, thank god, never used them and would t know where to start.ETA - found it .. need to display the "developer" toolbar.
My suggestion...
1. Record macro which just records you clicking on the tab you want and (optionally) moving to the first cell you are interested in
2. Add a Macro Button and assign the macro you just recorded.
Edited by sgrimshaw on Friday 2nd November 07:44
Cheers everyone, told the OH someone on PH would know

Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff


