Excel 2007 using inputbox to enter password

[CMSS]

I was wondering how to create a macro that opened an InputBox that requires a password input. Then, depending on the password entered, it locks/unlocks certain rows and columns.

[mojo249]

The following asks for password '123' and if it correct, unlocks range A1:A10 on Sheet1. If it's not correct, a message is given and it remains locked.

Please Login or Register  to view this content.