Multi-level Userform login Issues - Cells not remaining protected.

[Chardo]

I am currently having some code issues in regards to my multiple passwords I setup. For some reason the "basic level" or when someone opens the spreadsheet is allowing them to actually edit the ranges of "attendees","traveldates", and "location". These cells are only suppose to become editable after using the password "model" or supermodel". Does anyone know why these cells are currently editable when the the workbook opens instead of once the password is entered?

The first code is run when the commandbutton is pressed and the second code is when the workbook opens. I have included the overall file as well.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hong Kong 730PM.xlsm

[Chardo]

Does anyone have any suggestions as to why these cells are unlocked before the password is entered?

[Chardo]

Any help is greatly appreciated. I need to solve this issue in the next few hours if possible!