Multiple Users to Use Excel

I have a workbook, that has a lot of VBA code, & Userforms. I need to be able to share the workbook with a number of users. From looking at Shared Workbook in both the Excel Help and Google I'm a little concerned that it may not be the best way of doing things.

Can anyone suggest the best way I need to do this?

I had a thought about looking into who would be using the Workbook. It turns out that there will be 2 types of user, Full Access User & Read Only User.

My thought was to have a table which contains the UserID (from the Computer) Username, Access Rights & TimeDate Stamp.

When a User opens the Workbook it runs a query to find out who it is (I have a Function from Access to get the ComputerName) this would then tell what type of user they are. If they are ReadOnly is it possible to set the Workbook to ReadOnly? If the User was FullAccess I was looking at the idea that it would put a TimeDate Stamp in that field. Then if another FullAccess opens the Workbook it will let them know they cant update untill the other user has finished.

For this my idea was to use the Keypress commands, say I click on open an Edit button, It then puts TimeDate Stamp in the Cell, Once I click Save it then takes the TimeDate Stamp out, thus allowing anyone else to use the Workbook, and the same process as before.

Thanks for moving the thread, Does anyone have any ideas about #4 in this thread

OldChippy, Leith Ross, Have you had a chance to look over this thread?

Originally Posted by shg

Please Login or Register  to view this content.

Thanks for that, now is it possible for this to be done after looking in the tblUsers to find out if the UserID is ReadOnly or not?

I have posted the question on another forum to see if anyone else knows if there is a solution to my current thread

http://vbaexpress.com/forum/showthread.php?t=26126

From posting this thread into another forum I have received a reply but am struggling with part of it.

http://vbaexpress.com/forum/showthre...t=26126&page=2

I am trying to have the code below tell me if someone else who is in my list of Users with FullAccess under the AccessRights Column has Opened the Workbook and has a InputDate next to their name.

So I'm trying to write if the User = FullAccess, then check the InputDate column to see if there is any dates in the column where any Users with FullAccess are already in the workbook.

How could I do this?

Please Login or Register  to view this content.

Thanks for this Roy, I have amended mine now as that looked a far better idea.

My problem is that if the first person opens the workbook, it all works fine, but if I have someone else open workbook while person1 is still in the workbook, then excel automatically brings up the box to say ReadOnly and that do I want to Open,Notify or Cancel. How can I get rid of that box and use the code below to set whether the workbook is read only.

Please Login or Register  to view this content.

How is it possible to get rid of the pop up box telling you another user is already in the workbook?