I am sing "Group and Outline" in a protected sheet with some cells locked. I want all users to be able to expand and collapse grouped rows and columns.
The normal user doesnot have the password, so he is able to edit only the Unlocked cells. However, I want the normal user to be able to expand and collapse grouped rows and columns.
How do I do this? For my Excel file, the normal user is unable to Expand and Collapse grouped rows and cloumns.