Results 1 to 2 of 2

Thread: Grouping in a protected worksheet

  1. #1

    Question Grouping in a protected worksheet

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    Hi jenzach7,

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


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts