Would anyone be willing to look through my sheet and see if they could make it faster or more streamline. I have some redundant code in my book which I have a hard time figuring out what to remove. If what the sheet is trying to do is not clear then I can provide clarification
All required files are included in the zip folder extract them to c:testheadsets and make sure personal.xls is open as some of the macros run from there.
One more note I have a couple things in the project that have no use currently but may in the future so those can be left alone.
Thanks in advance if anyone takes this on.
Oh and just a general description of what this sheet does...it tracks what time a user is given his equipment and what time the user logs in for work. Also there is a save button (end day) that says the information on the active sheet to headsetouttimemay.xls
Everytime the spreadsheet is run it updates the names in column A for the persons that are scheduled to work for that day. This information is taken from the New Schedule file. Headset assignments is a currently unused file but the file headsetouttime still references it and it may be used again in the furture. DOH also is currently used to fill the combo boxes and may be used for other things in the future.
The change day button shows the daysoftheweek form and clicking on one of the days is what updates the persons scheduled for that day. When the form starts up a macro is run that enables manual calculation and shows daysoftheweek form.
Some of the code was written by myself and some of it (probably most of it) was written by other persons on this forum. So thanks for the help you have provided so far.
Bookmarks