Masking text in Excel

[davidhale]

I have created a spreadsheet to enable my shift managers to manage
attendance and staff training more efficiently. In order for them to
'sign off' that they have completed all tasks successfully I want to
put a password function in. Currently I have done the only way I know
how - using an If function to display when the password is entered
correctly. My problem comes when trying to disguise the text they are
inputting. I have currently set the font to Latha to stop the letters
displaying in the cell but any of the users with half a brain will be
able to change the font if they so desire and the text still displays
in the formula bar any how. I have tried hiding the formula bar but
this hides it for all spreadsheets and not just the one I'm asking
them to complete.

I have searched other groups and come across 'User Forms' but am
struggling to understand how to get this onto the spreadsheet itself -
can anybody help a VBA novice!!

 

[David Sisson]

Asterist for letters.
http://tinyurl.com/268zfc
http://tinyurl.com/26fs64

How to make a userform.
http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm


You can also password protect your project where you'll create the
userform. Click Project name, right click, select protection tab.