Hi everyone,
I have a protected worksheet that on opening, runs a macro and goes to cell "B11". Using the "Tab" key on the keyboard, the cells that it moves to, ie, the ones I have removed the protection from, are row driven in the order below:
B11, I11, G12, B14, I14, I7, L7.
I want to be able to change this order to:
B11, G12, B14, I11, I14, I7, L7.
In Tools >Options >Edit, I already have the "Move selection after enter direction" set to "Down" but because the worksheet is protected, it somehow disables this.
Does anyone have any ideas on how to achieve an ordered columnar tab rather than a row driven one? All assistance gratefully received.
Kind regards
Haydn
I have a protected worksheet that on opening, runs a macro and goes to cell "B11". Using the "Tab" key on the keyboard, the cells that it moves to, ie, the ones I have removed the protection from, are row driven in the order below:
B11, I11, G12, B14, I14, I7, L7.
I want to be able to change this order to:
B11, G12, B14, I11, I14, I7, L7.
In Tools >Options >Edit, I already have the "Move selection after enter direction" set to "Down" but because the worksheet is protected, it somehow disables this.
Does anyone have any ideas on how to achieve an ordered columnar tab rather than a row driven one? All assistance gratefully received.
Kind regards
Haydn