After I finished create the user form and all the function used t
calculate the working hours, I get stuck on this issue.. Is it th
spreadsheet with userform are multi-accessed by users?

Can I know who can answer my question?

Case 1:
Employee A and Employee B open the spreadsheet, filling up th
userform. The entries in userform will straight away pass t
spreadsheet behind the userform. If Employee A saved the fil
first...and Employee B still making the entries, is it when Employe
save the file later will overwrite the previous file that Employee
had saved?

Case 2:
Employee A access the file first, make some entries inside.... The
employee B comes in and make some entries(In the spreadsheet alread
have some entries that A made).... After that employee B saved the fil
before employee A do so. The entries that the employee A made withi
the period of B comes in and leave will lost or not ?

Can Excel handle multiple access? The shared workbook works... but I
juz allow 1 user make entries each time.

So, is it any possible solution for this... if juz using Excel? I'
getting headache man..

--
Message posted from http://www.ExcelForum.com

Why not create a new WorkBook for the user input, this way they will be
both saving in different workbooks and no data will be overwritten.

Another thing I think you can do is to create a temporary workbook for
the user data and when the user save it, check if there is some data
there already and if so save it in a new worksheet otherwise just save
in the activeworksheet behind the user form.

Just some ideas, I am new to VBA so I belive I can't help much more
than that.

Best Regards

NooK


---
Message posted from http://www.ExcelForum.com/