Your comboboxes are using a ListFillRange of CALCULATIONS!A2:A152. I checked them all and they all have the complete list. By the way, this range should be A3:A151. Even better would be to use a dynamic range, because the list of employees is certain to change.
Your code depends on the named range tblEmployees which is set to range =CALCULATIONS!$A$2:$A$92. However, your data goes to row 151 (see note above). So when you pick someone out of the combobox who is after row 92, the Find operation to look up the password doesn't find him. TO fix this, update your named range.the connected passwords only work for the first several guys on the list.
You should use the same named range to populate the combobox and to lookup employees.
There are known issues with ActiveX controls changes sizes, especially if you are using a display that with a resolution not native to the machine. A workaround is to replace your buttons with Forms controls. FWIW I do not have this problem when I open your file.
Bookmarks