Unprotect WS on clicking Group
Try the _SelectionChange(Target As Range) event. You could check for number
of rows/columns or cells selected to see whether to unprotect/protect it.
But since your second option is "reprotect when a cell/range" has been
selected, if a range has been selected it's going to take some examination of
the address of the selection to tell whether you've selected one or more
entire rows/columns or just a range that extends over several of them.
As you've laid things out, you're not going to accomplish much - I think
you've not told us about something, Jen:
Select several rows/columns = unprotect the sheet, and then
When 'individual' cell/range on the sheet is selected, put it back into
protected state?
Perhaps you want to put it back into protected state after a _Change to
values on the sheet takes place?
"Jen" wrote:
Hi There,
Would it be possible to unprotect my sheet when I push on the +'s and -'s
for grouped rows (columns)
&Reprotect when a cell/range on the sheet has been selected?
I have no idea on where to start this one .. I am sure it is some
worksheet-event code but ...
:(
Brgds Jen
|