Ken Puls
04-23-2007, 01:25 PM
Hi guys,
I've never tried to do this, and haven't been able to find anything on the internet about it either.
I'm trying to hold a string for a password, and want to pass it to the Protect Sheet dialog box if I can. I know I can show the dialog with the following...
Dim dlg As Dialog
Set dlg = Application.Dialogs(xlDialogProtectDocument)
With dlg
.Show
End With
... but none of it's objects are exposed here. I'm curious if anyone has done this, or if it is possible. If not, I'll just build my own userform interface, but if I can avoid it, I'd rather.
Thanks,
I've never tried to do this, and haven't been able to find anything on the internet about it either.
I'm trying to hold a string for a password, and want to pass it to the Protect Sheet dialog box if I can. I know I can show the dialog with the following...
Dim dlg As Dialog
Set dlg = Application.Dialogs(xlDialogProtectDocument)
With dlg
.Show
End With
... but none of it's objects are exposed here. I'm curious if anyone has done this, or if it is possible. If not, I'll just build my own userform interface, but if I can avoid it, I'd rather.
Thanks,