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.
| +169 | How to stop feeling like shit for not making it in IB? | 63 | 5h | |
| +123 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 59 | 13h | |
| +85 | Updated LA Banking Scene (2024) | 61 | 8h | |
| +40 | Ranking banks that went under | 24 | 8h | |
| +39 | Burnt Out M&A ASO | 22 | 2h | |
| +36 | Relevance of A-Levels for U.K. London recruiting | 25 | 6h | |
| +33 | A strategy for SA applicants late to the game like myself | 17 | 6h | |
| +31 | Intern Ettiquette | 5 | 1h | |
| +27 | Series 79 Help / Tips to Pass The First Attempt | 11 | 3d | |
| +23 | What are hours like at BBs in London? | 47 | 1d |
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.
Delectus numquam ducimus qui ea. Sit non quibusdam fugit repellat totam. Mollitia eligendi fugit nulla sed.
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...