Protecting only certain cells in a worksheet

[Sumit Khanna]

Hi. I have a template that where I want users to update
certain cells only. I was able to accomplish this by
protecting the worksheet while unlocking the cells that
need to be updated.

The problem is that the rows containing the unlocked cells
are grouped. I want the user to be able to ungroup them if
necessary. I have tried selecting the entire rows and
unlocking them but seems the grouping thing still does not
work.

Any suggestions would be sincerely appreciated.

Regards,
Sumit Khanna

 

[Jim Rech]

I think your only choice is to give users a macro to run that does the
unmerging. The macro would have to unprotect the sheet, do the unmerge, and
reprotect the sheet.