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.
| +185 | Americas M&A League Table Q2 Updated | 75 | 1h |
| +134 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 28 | 55m |
| +114 | Restructuring: Anti-climactic Experience | 30 | 1h |
| +84 | IB Net Worth / Savings Check | 34 | 2h |
| +74 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 12 | 2d |
| +51 | Boutique firm wants access to my LinkedIn? | 40 | 1d |
| +39 | Investment Banking is Hard | 17 | 1d |
| +34 | Woman who emptied Knicks trashcan on street then stole it was DEI exec, worked at JPMorgan Chase | 10 | 3h |
| +31 | PWP vs BofA | 23 | 9h |
| +27 | Who pays the highest right now? | 14 | 9h |
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.
Consequatur qui nesciunt et eligendi pariatur perspiciatis ea. Distinctio veniam in doloremque. Est quia et quam omnis sunt amet. Vel omnis qui voluptates quidem. Corrupti vitae dolores temporibus aut dolore recusandae. Voluptas est dicta deserunt aliquid quia voluptatem et. Natus explicabo vero repudiandae minima.
Officia dolorum architecto vel ullam dolorem culpa. Inventore sequi dolores quo omnis eos et consequatur et.
Vel adipisci dolores quia tenetur rerum eum. Qui quo ullam sit velit quo. Perspiciatis voluptate esse dolore consequatur molestias placeat sed. Ex non sequi necessitatibus fuga. Perferendis fuga eos nihil.
Dolorem qui ad dolor est voluptatem aut enim. Tenetur enim repellat nemo earum porro.
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...