Results 1 to 3 of 3

Optimizing code

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-03-2009
    Location
    USA, California
    MS-Off Ver
    Excel 2007
    Posts
    385

    Optimizing code

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1