Expanding and Collapsing Groups within a Protected Workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi blue,
In Excel 2003
Click to expand...
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.
Click to expand...

I do not have xl 2003 but I think there is an option what you can do
and what you cannot in the menu you use when protecting. So look at
what options are in "Extras/Protection/ProtectSheet Users are allowed
to ..." and activate filter and grouping.

Otherwise, with VBA, before protecting run

For i = 1 To ActiveWorkbook.Sheets.Count
Sheets(i).EnableOutlining = True
Sheets(i).EnableAutoFilter = True
Next

to allow Outlining and Filters on all sheets.

arno
 
Back
Top