Input Password form with masking

[raj08536]

I need change in the VBA to create Input Password form with masking


Sub Unprotect()
Dim i As Integer

Dim Pwd As String

Pwd = InputBox("Enter your password to unprotect all worksheets", "Password Input")

'Lock all the cells that are selected color

For i = 1 To ActiveWorkbook.Worksheets.Count

Sheets(i).Activate

Sheets(i).Unprotect Password:=Pwd

Next i

MsgBox "Worksheets are unlocked!!"

End Sub

 

[dmt32]

Hi
have a look here:Mask your Password with this VBA InputBox - wellsr.com
provides code to do what you want.

you can also do this by creating your own custom inputbox with a userform

Dave