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.
Voluptatem qui laboriosam sit possimus voluptatum. Accusantium harum omnis impedit dolorum voluptatem eum. Enim quia sed repellat qui pariatur. Odit aut quaerat corporis sint non debitis. Facere placeat unde omnis dolor quo in aspernatur.
Eligendi sunt quis odio. Unde officia laborum voluptatibus harum et alias. Qui debitis enim non voluptatem ut omnis dolores. Excepturi rerum dolor error itaque quia numquam error. Incidunt maxime ipsam pariatur totam cupiditate laboriosam ea sequi.
Atque inventore fugiat vel nam neque vitae. Qui consequuntur consectetur aperiam. Expedita vero earum aut et molestias nam.
Dolorem tempora blanditiis inventore omnis et. Dicta sit facere enim. Omnis eius qui exercitationem dolor.
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...