Grouping in a protected worksheet

[jenzach7]

I understand how to protect a worksheet and how to allow grouping (the + and - buttons), but once I protect is disables that grouping function. I have no knowledge of macros or coding - I can see that there should be a way to use those to make grouping and protection work together, but it's out of my level.... can someone break this down? I am using Excel 2010.

[DILIPandey]

Hi jenzach7,

Sheet protection disables grouping function but you can see below link where MVP Debra showed a way:-

http://www.pcreview.co.uk/forums/do-...-t1054601.html

Regards,
DILIPandey