Can anyone suggest a way to unlock a range of single cells
let me do some work
and then re lock them again
Starting from P11
every 6 columns right till AZ11
and every 7 rows down to the last row (around 13000ish)
eg.
P11, V11, AB11.....AZ11
P15, V15, AB15.....AZ15
.
.
.etc
I could ctrl click/every one
format
protection
unlock
do my work then start over, but I think thats gonna cause RSI and i need my hand for other things, like raising a toast to the guys on this forum
Oh please let there be an answer!!
Martin
let me do some work
and then re lock them again
Starting from P11
every 6 columns right till AZ11
and every 7 rows down to the last row (around 13000ish)
eg.
P11, V11, AB11.....AZ11
P15, V15, AB15.....AZ15
.
.
.etc
I could ctrl click/every one
format
protection
unlock
do my work then start over, but I think thats gonna cause RSI and i need my hand for other things, like raising a toast to the guys on this forum
Oh please let there be an answer!!
Martin