|Subject:||Protecting only certain cells in a worksheet|
|Posted by:||Sumit Khanna (sk_nj_ju…@yahoo.com)|
|Date:||Thu, 9 Oct 2003|
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
Any suggestions would be sincerely appreciated.