Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Password Format for a cell

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,
    I want a cell in excel to store a password.
    How can I do that?
    Thanks,
    Karthik.


  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi --

    Choose your cell and type the passwork needed

    Use Auto_Clse in VBA to set on close the password in cell XXXXX, this will look to see the text and save password as that/

    Does that help?


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Here's one way to protect or unprotect a sheet by entering the passwords in a cell. Try this in your worksheet module. Before doing so, be sure to unlock cell A1 or whatever cell(s) you want to have access to. Modify the passwords as you wish, although the ones in this example are excellent choices.

    '''''''''''''''''''''''''''''''''''''''''

    Private Sub Worksheet_Change(ByVal Target As Range)
    If [A1] = "Tom" Then
    ActiveSheet.Unprotect
    ElseIf [A1] = "Urtis" Then
    ActiveSheet.Protect
    End If
    End Sub

    ''''''''''''''''''''''''''''''''''''''''''

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •