I'm not certain that my issue can actually be solved bound by the limitations of Excel itself.

I've been developing a workbook for employees that has seen multiple revisions due to...new ideas being brought up.

First, was a drop down menu for certain jobs, easy enough.

The second, was for Excel to print all the dates between two user or admin inserted dates across a row, done.

Third, was that the weekends of these dates needed to be shaded gray, OK.

The forth, was that certain sections of an individual's worksheet had to be pre-populated with information, doable.

The fifth, was where things got a little tricky. Creating a button to insert new row.
-Had to delve into VBA code to do so, but not too difficult. Done

Next, was to create a login system where when one employee logs in they're able to see and modify their own sheet, but not see or access anyone else's.
-Back to VBA and complete.

It's this last one that threw me for a loop.

The workbook should be web enabled.

I started off by trying most file sharing sites. Microsoft, Dropbox, Google Drive, OneDrive and SharePoint. I've run into the same issue; none will carry over the VBA code for multiple people to access it online. They can download the file and everything works, but if two or more people download, edit and re-upload the workbook at the same time data is lost or I end up with two dozen different files.

So with a little bit of research I found that no host can carry over the VBA that's necessary to do what I need it to online.
-By all means if you know a site that could be used please let me know.

So I've come up with a few options:

1. I find an alternate way to code the VBA. -I would need a lot of help on this one.

2. I remove the login system, have all sheets visible but lock the cells of each sheet behind passwords for each user. This would also eliminate the insert a row button.

3. Divide every individual's sheet into separate workbooks and hope merging them before processing them won't cause format issues.

I'm honestly at a loss after half a week of research and before anyone brings it up, yes, I know there are alternative programs for clocking employee work and time, but I've been told that excel HAS to be the product we use.

From what I've read I don't think it's possible for Excel to even accomplish this task; it's just too limited. Either way, if anyone knows an alternate way to code these last two things without VBA or a hosting site that can keep the VBA code I would love to know.

If this is impossible, which I'm pretty certain it is, what are some suggestions you would have about an alternate way to build this workbook?