Unprotection of outlined data in protected worksheet
Is is possible to collapse and uncollapse outlines data when a worksheet is
protected by clicking on the "+" "-" buttons or the "1" "2" etc buttons. I
have a workbook on which one of the sheets in interactive for people to
complete, however I need to protect some of the cells and then protect the
worksheet so that formulas and some data cannot be amended. To make the
worksheet interface userfriendly, I have outlined some columns and rows.
However, when I protect the worksheet it does not allow me to use this
functionality.
Please can someone help and advise if this function is still possible when
protecting a worksheet, and if so, how?
many thanks
Afsha
|