Unprotect noncontiguous cells

[Lee733]

How do I unprotect cells that are not contiguous to each other in a protected sheet? For example, unprotect cells E8:E27 and A27. All other cells would be protected.

Debbie

 

[Jeffrey Mahoney]

What are the rules? I mean this sounds a little like Minesweeper. Are you allowed to choose a seed cell? Are non-blank cells diagonal from the last cell considered contiguous?

If my seed cell is E7, then does this look right? Cells in columns F and G would be excluded?

Main.xlsm
	A	B	C	D	E	F	G
1
2
3
4
5		34	E	A		100
6				B			200
7					C		300
8				D			400
9				1		500
10				2		600
11				3		700
Sheet4