Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2004
    Posts
    78

    Question Unanswered: Cell format = Password

    Can we change format of cells in excel using VB or directly so that what ever we type in cell shows up as ****** and the value is stored as typed value and not *****.

    Thanks.

    ~BS

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    i dont think so but i suppose it could be fudged
    why not just add a textbox to your worksheet and set the password character in there

    Dave

  3. #3
    Join Date
    Dec 2004
    Posts
    78

    Thumbs up

    I guess ur trick should work. Need to try out though.

    Thanks.

    ~BS

  4. #4
    Join Date
    Feb 2004
    Posts
    533
    You could use the Cell Change event to change the font to a 'Webdings' font after the user changes the cell. Then all anyone needs to do is select the cell and view the text unaltered in the formula bar... So you could turn off the formula bar, but then anyone could copy the text and view it in a clip-board viewer to see whats typed. Like Dave suggested, you might consider using a Textbox or Textbox on a userform. With the Textbox you can set a Mask option, and select the caracter to use as the mask character.



    /
    ~

    Bill

  5. #5
    Join Date
    Dec 2004
    Posts
    78
    Textbox works perfectly fine.

    The only problem is that if a value is changed in the textbox, user needs to save the sheet to store the new value. Is there a way to only save the contents of textbox without saving the whole sheet.

    Thanks.

    ~BS

  6. #6
    Join Date
    Feb 2004
    Posts
    533
    Quote Originally Posted by bhavesh78
    Is there a way to only save the contents of textbox without saving the whole sheet.
    Have the Textbox value pull from another workbook, .INI, or text file. Either read/write values from the external file or use a hidden workbook to store the password. Then you can save the password changes without saving the active workbook. This of course requires different coding to refer to data in a separate file or workbook. A little more complex.



    /
    ~

    Bill

Posting Permissions

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