Hi
I would create (record) a macro which first unprotects the sheet, then
ungroups your data and protects the sheet again.

--
Regards
Frank Kabel
Frankfurt, Germany

bayhe wrote:
I have a worksheet where I grouped some of the columns and rows.
(data -- group and outline -- group).
At the same time, I need to protect the worksheet with password so
that the locked cells would not be edited.
The users need to be able to group or ungroup the cells (by clicking
on the +/- button).
What should I do?
Any replies would be greatly appreciated.