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.
| +126 | Do people still want to go PE? | 38 | 1h |
| +101 | UBS Tech layoff | 44 | 33m |
| +78 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 19 | 27m |
| +39 | How do YOU manage networking requests? | 8 | 50m |
| +37 | Lazard hirevue | 11 | 2d |
| +36 | What Differentiates the Best Analysts as AI Improves? | 9 | 2d |
| +32 | MBB Pay Raises | 17 | 55m |
| +31 | Quitting After First 4 months | 10 | 1d |
| +28 | Are target prospects getting dumber? | 11 | 19h |
| +27 | Cornell Club T10 Rankings (UPDATED 10/2026) | 18 | 3m |
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.
Repudiandae autem et non perferendis amet repellendus omnis ipsam. Eligendi ad ratione mollitia error. Cum ipsam totam eligendi mollitia asperiores inventore a.
Consequatur quia cumque autem. Iusto inventore rerum qui rerum provident iure. Explicabo architecto assumenda quo.
Modi quia qui et consequuntur molestias. Voluptatem dolorem totam ut voluptatem eligendi saepe. Incidunt voluptatem tenetur explicabo voluptatem aut saepe earum. Perferendis velit fugit molestiae voluptate suscipit nostrum et.
Et sit neque odit corrupti. Harum autem sequi quas maiores. Laboriosam vero occaecati eius placeat vero in eaque. Saepe dolorem blanditiis quis nesciunt quis in quia.
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...