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