Expand and Collaps Groups while Protected

B

blue

In Excel 2003, I created groups that are expandable and collapsable (by
clicking on the + and - notations on the left) through Data->Group and
Outline->Group.
This group contains two columns where column A is locked and Column B is not
locked.
When I apply protection on the worksheet in order to avoid any changes to
Column A, the functionality of expanding and collapsing the group is not
allowed.
Is there any way way to still allow the collapsing and expanding of groups
while protected?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expanding and Collapsing Groups within a Protected Workbook 1
Automatic Emails sent to my Contact Groups by Microsoft 1
Assigning a key to expand or collapse a group 2
Expand all groups 1
expanding or collapsing groupings in protected worksheets 5
cannot expand outline on protected sheet 2
Expand All groups 2
User controlled Freeze Pane while protected 3

Top