I have looked online for this answer and based on my results, I cannot tell what I am doing wrong. Upon opening an Excel workbook, I want to declare and set a global constant. I have the following codes to do this. However, when I manually try to unprotect the worksheets, they have no password. Even when I put a MsgBox in workbook open, it shows the right password.