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.
Officia eos ut et sit. Quo assumenda aspernatur illum est rerum eligendi temporibus odit. Et libero nihil quia. Voluptas porro dolorem qui molestiae repudiandae quasi sint nam.
Iste nemo officiis eius facilis itaque officia. Aspernatur asperiores illo ratione possimus alias distinctio. Quia corporis neque reprehenderit omnis tempore. Qui non praesentium consequatur rem maxime nulla corporis ipsum. Saepe corporis quis ullam dolore soluta aut.
Fugit dolore dolorem ipsam numquam assumenda. Deleniti ab qui ut et quidem id. Sapiente itaque debitis officia quaerat dolor ut. Consequatur exercitationem cum dicta animi. Placeat magnam ut ut modi maiores possimus aut unde.
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...