VB Code to perform an action, when user selects a particular cell in MS Excel

[Razanust]

Hello, I wanted to develop a code in VB inside MS Excel that allows the user to select his name from a drop down menu placed in an Excel Cell. Then the code asks the user for a password against his username and further unlock selected columns for him to edit. I have created a drop down list via this help: http://spreadsheetpage.com/index.php/tip/create_a_drop_down_list_of_possible_input_values/[^] How to proceed further for asking the user for a password?

[Lost User]

Excel has a built in system for password protecting worksheets or specific cells.

[Razanust]

Yes I discovered that previously. What I want to do is to create a multiple user access inside the excel sheet.

[Lost User]

Then you would need to write a VBA macro which runs automatically when the spreadsheet is opened. Try one of the Excel forums that Google will find for you.