Unprotect Cell on result of given cell

[adam2308]

Not sure if this should be in the programming forum o the general so i'm going to guess at programming.

On the attached example i have all cells except those needed to be entered into password protected. However, when i choose 'league' from the drop-down in B2 i want cell E5 to become unprotected without having to input the password.

Thanks.

[royUK]

You could use the worksheet_selectionchange event

Please Login or Register  to view this content.

You would also need code to re=lock the cell - see this similar post

[adam2308]

Sorry i've added the code above but it still is not unprotecting cell E5. I have attached the sheet again with the code. Am i doing something wrong?

I meant to say in the original post, the password to protect/unprotect the sheet is 'Password', if this is needed.

[modytrane]

Try the attached file.
modytrane

[adam2308]

it seemed right when i first opened the file as i was able to edit E5, when i changed B2 to Tournament that was fine as i could no longer edit E5 (which is correct) but when i changed B2 back to League i could not edit E5 anymore.

Thanks for your help so far.

[modytrane]

it seems to work for me.
try again. I've attached the file again.
modytrane

[adam2308]

This works when i choose E5 with the mouse but if i tab through the cells it skips E5 when league is chosen but goes to the cell when tournament is chosen. Although, for some reason it tabs correctly at first but if you tab through the cells again it does as i say above.

[modytrane]

You are correct about excel behavior depending on how you select the cell.
The macro written by royUK needed to be installed in Worksheet and its a Wroksheet_SelectionChange Event macro.
I have had similar expereinces with these types of event macros.

I don't know enough about excel to explain this, but one of the experts here will be able to answer this.
I am interested in the answer as well.

modytrane

[adam2308]

thanks modytrane. Hopefully one of the experts will be able to help us solve this.