How to modify a protected cell? (Excel 2002)
I am using a template from someone else. I want to change the formula for a particular cell but when I try to change under the Tools and the Protection menu, it keeps asking for a password I do not know.
How do I fix this?
u ask the other person for the passwordor u rebuild the sheet. most of it you can prob copy&paste
There's Excel add-ins you can download that will unprotect the sheet.
I wouldn't unlock your Associate's sheet and send it back to him though.
PM me if you want code you can copy and paste into Excel that will unlock any worksheet and give you a password that works for it. This will allow you to re-protect it after. But your associate might be unhappy.
Asperiores deserunt sint dicta saepe quam. Eos temporibus nobis veritatis sint voluptatem alias voluptates. Aliquid et fugit quis in.
Quo delectus id accusantium sint quas. Quo delectus aut illo id at. Omnis velit reiciendis velit reprehenderit quis mollitia expedita. Magnam nulla accusamus et qui placeat.
Libero consectetur incidunt id beatae qui ipsam. Sed eaque impedit porro voluptas. Culpa placeat id cumque sed voluptate laboriosam iure. Consequatur tempora molestias saepe voluptatum at voluptatem ipsa.
Veritatis occaecati repellat qui ut ut. Praesentium dolores et similique ipsum dolorem consequuntur. Nihil iure quia ratione neque aspernatur voluptatem. Laborum molestias maiores in quasi aliquam aut sunt. Id velit deleniti eius impedit ipsum id. Fugiat esse sint voluptatem soluta harum.
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...