Expand/Collapse disabled

[Former Member]

Hi experts,

I would like to ask on how can i enable the expand/collapse button if the report templates are already locked?

i tried to unlock the ID cell which i need to expand or collapse, but when i put the protection to my workbook, the button for expand/collapse still become disable.

i also tried to check all the checkbox in users option but still disabled.

Thanks and Best Regards,

[Former Member]

Hi Marlon,

Do a full expansion of the data, use grouping to act as expand / collapse.

when you protect the sheet make sure you allow them to use the grouping function. so the rest of the sheet is protected.

Andy