Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default passwords in fields...

I have a puzzle that I need to know if it can be done...

I have a worksheet that I need data completed on and it contains these
columns.
Column 1 contains usernames that I provide in the document. The second
column contains a field the users that i give access to can input their
password in that they current use to access an application.

1 Username Password
2 name1 p.assword
3 name2
4 name3


I need users to complete this sheet filling in their password in column 2.
After the cell is complete and they press enter, i would like the cell to
***** out the entry and lock it so it can't be viewed/changed by anyone
except the document creator (me).

When the next viewer opens it, they will see this
1 Username Password
2 name1 *******
3 name2
4 name3

When the document owner opens the owner sees the password reveled...
1 Username Password
2 name1 p.assword
3 name2
4 name3

Note as an option the field could be password protected so the owner of the
document could type to reveal the hidden password...

Is there a way to do this in excell... without doing much programming.....

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
fields names do not show in excel 2007 pivot table fields list marlo17 New Users to Excel 2 December 1st 08 01:25 PM
how can I convert data with fields in rows to fields as columns PiyushAg Excel Discussion (Misc queries) 3 July 2nd 07 05:46 AM
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! PSSSD Excel Worksheet Functions 2 August 8th 06 09:31 PM
number of fields in the row fields in pivot table UT Excel Discussion (Misc queries) 0 April 13th 06 01:17 AM
Need pie chart with number of fields instead of info in fields Lloyd Pratt Charts and Charting in Excel 1 September 21st 05 11:56 PM


All times are GMT +1. The time now is 02:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"