I have a spreadsheet that has several groups of rows. I need the worksheet to be protected, except for the cells that have to be edited by the user; however, when I protect the sheet I cannot then use the group indicators on the left hand side of the screen.

I have tried all ticks and no ticks in the protection selection, but none of these allow the group selectors to be used.

Is there a way through programming that can overcome this problem please?

Regards

ValleyWatch