Running through model that has a sheet which needs to be protected. However, there are hidden rows that I would like for the other user to be able to toggle (unhide, hide) with that [+] button. How can I allow him to do this while the sheet is protected?
Tried Ctrl+1, P to see if I can unlock that row but it doesn't seem to work. Monkeys, any tips?
Thanks.
| +220 | UBS Accused of Favoring H-1B Workers While Cutting U.S.-Born Employees | 51 | 20h |
| +114 | ONLY THESE BANKS OR YOU STRUCK OUT | 33 | 5h |
| +110 | IB Energy Drink Tier List / Ranking | 72 | 1d |
| +91 | PJT M&A Group Selection 2026 | 14 | 1d |
| +55 | Firm Thinks I'm Lying About Offer | 18 | 17h |
| +51 | Feedback for internship first desk at IBD BB - personal fit, "don't be too confident" | 29 | 1d |
| +33 | Stay at Weak Dealflow Team or Lateral? | 10 | 2h |
| +30 | Does BofA still pay its associates rat pellets? | 15 | 1d |
| +30 | Indiana University Fraternity Pipelines | 15 | 1h |
| +28 | Rogo AI | 8 | 40m |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
did you try unprotecting the whole sheet, grouping, and then protecting again?
It's one of the protection options when you protect the sheet. I forget which one. Take a look.
I recall having this issue with Excel 2002/XP and I believe back then this was simply impossible to do - it was not one of the options. I think I recall this changed from 2003 to 2007. But the entire group/ungroup thing is still not fully integrated into Excel - seems like a last-minute add-on. I dont think that VBA can press that +/- button for example.
Minima est quo voluptates suscipit laudantium voluptas dignissimos. Repellat nihil nam sunt ut libero eveniet. Sit corporis soluta omnis non fugiat.
Est aut sint omnis id magnam nesciunt. Voluptatem atque tenetur aut. Vel consequatur aut sapiente.
Ducimus eos facere mollitia quos. Officiis itaque numquam aut qui accusamus expedita exercitationem. Dolor saepe debitis sapiente quo ut sed.
Dolorem occaecati beatae quisquam quidem amet. Facilis amet fugit omnis aperiam a quos. Et quidem repellat quam libero est. Veritatis nobis eum qui ipsam aliquid voluptatem totam.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...