I have worksheet which has many rows which I have grouped. I have protected
the worksheet to allow users to only input data into particular cells.

I would like to give the users the capability to Expand/Collapse the grouped
rows, but I cannot find a way to do this - basically, if the worksheet is
protected then the Grouping buttons do not work.

Using Excel 2007

Any suggestions please?

S