data grouping with worksheet password protected

xlgooroo

New Member
Joined
Sep 19, 2006
Messages
4
i have seen similar questions posted prior but no replies...

if i group a row of cells using data...group...rows and password protect the worksheet, the group/ungroup feature doesn't work, even if I unlock the cells that were grouped.

is there vba code or another, simpler solution to this problem?

thanks in advance
xlgooroo
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,114,093
Messages
5,545,916
Members
410,711
Latest member
Josh324
Top