I have a fairly involved question. I'm trying to create a payroll calendar. The way it's meant to work is that users start by viewing a calendar. When they click on a day, they get a menu with 1) a drop-down list of employee names, and 2) two blanks for entering when they started and stopped working).
What I need help with is:
* Making the calendar areas clickable (do I use a command button, or something else?)
* Making a menu with the options I mentioned (names from a different sheet in the workbook, blanks for times).
* Automatically entering the results into a different spreadsheet.
Thanks for your help!