Password Protection

Unprotect and Protect the sheet using the below code

Please Login or Register  to view this content.

Userinterfaceonly:=True will disable manual inputs and allow the macro to change the cells without unprotecting the sheet.

So your current code don't need any protection and unprotection

Please Login or Register  to view this content.

I don't know whether you got my point or not

Glad it helps you and thanks for the feedback

When you allow the users by way of applying the sharing then it's not going to be a right approach. I give below the practical difficulties for your reference.

Cells(Rows.Count, 4).End(xlUp).Offset(1) = Now

The above line of code will add the start time in the last cell. Assume that three persons are started the work and the second person finished the work and pressing the Stop button.

Cells(Rows.Count, 5).End(xlUp).Offset(1) = Now

Will put End Time for the First Persons entry. Is it right?

From my point of view keeping a single file and sharing the file for 10 persons is ok but I don't know how much you are aware of the issues of shared workbook and it requires some maintenance too...

I will give another probability for you...

Assume that 10 persons are working in shared workbook and the users on shared workbook should Save the file before/after doing any entry. Doing save before doing any entry is to see the changes of other users so that we can pick the next blank cells for our use. Doing Save After the entry will let the persons to know the change that you have done.

In this case assume that 2 persons are pressing the Start button on the same instance in that case the code will run and pick the last blank row and put the start time but when both press ctrl+s in that time it will show User Conflict message box by showing both of the entries on that cell.

So the user should decide which one to keep and which one to be ignored. That time the user should move his entry to new blank row and press accept others option. Again when doing all those things other person might have generated another start time in that new row then again it will leads to conflict.

You know some lazy persons as I seen at my work place they simply press Ignore Others and Accept Mine button because they are not interested in doing all these process. Due to this we see lot of missing entries because some of them are replaced it with their text.

So it's your choice to pick the comfortable one

Originally Posted by sam2424

It gives error to new spreadsheet until we run macros manually. By any chance can we fix it???

Not sure what error is that and the above statement is also not clear about why the error is occurring and all. If possible please brief it for better understanding

What version of excel you are using? Is it excel 2013?

The error denotes that the sheet is protected manually so when you try to access the protected range then vba throws the error because of no access. So it is asking you to un-protect the sheet, I think so...

Please confirm...

Post #14 is having the reason and the rectification method

Hi you.
i know a way that can help you. I think it is the best way for you ti fix your problems. It is a add-in A-toos in Excel, it can help you to share your excel file in LAN or in Internet. In addition, it can help you to authorization for the other computer, what can connected to open what kinds of Excel file, what kinds of sheets, which have authorization to edit or only view, copy or print?

Thanks you.

bluesoft, please do not post links to commercial sites here