G
Guest
I am trying to do something that should be VERY simple, but doesn’t work.
I have two columns of data, such as
A B
3 ff
2 aa
9 rr
7 pp
I turn on auto filtering which allows me to filter both columns. Then, I
lock all the cells except the A and B. Then, I lock the worksheet with the
Sort option checked.
Then, while I can still use most of the options in the auto sorts, except
the Sort Ascending and Sort Descending generate a dialog saying I need to
unlock the worksheet. ANY help would be greatly appreciated.
I have two columns of data, such as
A B
3 ff
2 aa
9 rr
7 pp
I turn on auto filtering which allows me to filter both columns. Then, I
lock all the cells except the A and B. Then, I lock the worksheet with the
Sort option checked.
Then, while I can still use most of the options in the auto sorts, except
the Sort Ascending and Sort Descending generate a dialog saying I need to
unlock the worksheet. ANY help would be greatly appreciated.