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!!