Protecting only certain cells in a worksheet

Giganews Newsgroups
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
work.

Any suggestions would be sincerely appreciated.

Regards,
Sumit Khanna

Replies