Hello,

Okay, I've beat my head against the wall here. I'm trying to set/unset workbook (and worksheet, but that's not the issue at hand) protection via code. I'm trying to check if the workbook has a password before I set any kind of password. The process I'm using isn't working. It always evaluates to False. Anybody see anything wrong off hand? (I'm sure I'm looking too closely..)

If ActiveWorkbook.HasPassword Then
        If MsgBox("Are you sure you want to delete the WorkBook Protection?", _
            vbYesNo, "Delete WorkBook Password?") = vbNo Then Exit Sub
        'Do something here...
    Else
        MsgBox "You don't have a password on this Workbook!", vbInformation, "ERROR"
    End If

By off-chance, does anybody know how to get Excel's native password dialog box to pop-up, as so we can use that instead? I hate doing more than is necessary..