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

Thread: Hide a personal ID code in a cell

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a worksheet that gets reviewed by various people. I am looking for a way that after a person reviews the worksheet that they can type in an assigned ID code to varify it has been reviewed, but I don't want the ID to be visable(maybe ******) to the average user. Security does not have to be real high just enough to attempt to keep everybody honest. Any suggestions

    Thanks

    Scott

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

    Default

    Highlight the cells you want the user the enter the ID code and Select Format > Cells > Protection tab. Uncheck Locked and check Hidden. Click OK. Format the cells with a non-character font such as windings. Password protect the worksheet by selecting Tools > Protection > Protect Sheet and enter a password.
    It's never too late to learn something new.

    Ricky

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

    Default

    i often add Excel security is very basic and takes advanced users a few seconds to bust it open, some tricks are harder but not impossible if hard we rip the data so dont even need to get into it,

    Just so you know im not posting this to be a fool, just warning NOTHING is scure and so you need to be awair that no one is protecting you.

    I can more or less get into ANY files passwords now also, but takes time... but yo will stop the idiots that have the odd look i guess.

    Take care... no secure fix bar do not give the data that you dont want guys to see in the first palce.


    Free Excel based Web Toolbar available here.

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

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The hidden check box in properties was what I needed. Thanks for the help.

    I do realize that security is not much of a reality with excel, but it is good enough for what I need in this situation.

    Thanks again.

    Scott

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
  •