I need some help using Forms and Excel macros. I'd like to write macros to add and delete people from the list and then automatically update the drop-down box to reflect the changes. Then also put the list in alphabetical order and correctly number the list so I can then use VLOOKUP as shown in the attached sheet. Also, would like to somehow password protect the macro so only supervisors can do these tasks. Does not need to be an ultra secure password protection, could even be a hard coded passwork listed in the macro that uses a MsgBox to ask the supervisor to enter the pwd.
Thanks,
Brett
Bookmarks