Can someone please help me here. When entering password or authourised
code in the text box, I would like it to show xxxxxx and not display
the password. Please see below the vb code i am working on.

Many thanks for any help.

Ola.

Option Explicit
Dim sPrompt As String
Dim vPW As Variant
Public cntr As Integer




Private Sub Cmdok_Click()
If TxtPW.Value = "55555" Then
frmAuthorisation.Hide
Call CreateTemplate
Me.lbldone.Caption = "A total of " & iWCount & " workbooks" _
& " containing a total of " & iCCount & " worksheets created."
Me.lbldone.Visible = True
frmAuthorisation.Show


Else
cntr = cntr + 1
If cntr = 2 Then

MsgBox "SORRY..YOU HAVE ENTERED AN INCORRECT
PASSWORD...GOODBYE!!!"
ThisWorkbook.Saved = True
ThisWorkbook.Close


End If
End If

End Sub



Private Sub lbldone_click()

End Sub

Private Sub Label1_Click()

End Sub

Private Sub cmdcancel_Click()
Unload frmAuthorisation
End Sub

Private Sub TxtPW_Change()

End Sub

Private Sub UserForm_Click()

End Sub