clear password protected combo

I have a combo box that is a list of names. When a EE chooses their name they must also enter their password. at the end of a batch I have a button that clears cells. I put in this code

HTML Code: 

to clear the combo box, but it ask for password befor clearing. how do i stop it from asking for password or how do i creat a macro that hits enter key?

In the sheets Open event, you should password protect it using the UserInterfaceOnly option. Set properly, your code will then not need to get and set the sheet password.

e.g.

Please Login or Register  to view this content.

Sheet is, but thats not whats causing the issue. Its the names that require a password to select it also requires it to clear.

Post a simple workbook showing the issue and include any passwords.

By the way, I would not name a combobox the same as a range.