Zack Barresse
10-27-2004, 04:35 PM
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.. :rolleyes:
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.. :rolleyes: