Excel 2007 Question
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.
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.
Aut sed ducimus est enim deleniti excepturi. Molestiae ullam ut quia excepturi soluta qui. Rem non quam delectus nostrum eos. Illum iure quaerat provident consequuntur facilis et. Ullam a ea voluptatibus quasi distinctio molestias consequuntur.
Dolore facere aperiam sed eveniet sit aperiam asperiores. Quae ut totam sunt. Id quis velit id ipsam odit quia.
Ut iusto praesentium totam in officia natus consectetur. Nulla libero ut voluptatem voluptatem tempora nulla quis. Dignissimos pariatur ipsum suscipit.
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...