Creating a Multi User Log Sheet

[kirbyfez]

Hi all,

Again I am in need of the communities vast experience and knowledge.

I am trying to create a multi user secure log sheet. The whole goal is to create a logging system for call logging at work.
Currently what I have is that everyone uses there own workbook and fills out everything and at the end of the week, I run a macro which merges all the files together.

However I've been working for a long time upgrading this to a multi user thing.
That multiple users use the same workbook.
My thought is that there will be one workbook per team. 15 agents per workbook.

Each agent will have their own sheet, it will be shared so they can all use it at once. Thing is that I need to ensure that the agents can not see each others work.

The current way it's set up is that when the log sheet is opened, there is only one sheet and the rest is on veryhidden. If macro's are turned on, a macro will run and the rest will appear. This to ensure that all agents have activated macros.
Then the macro goes through each sheet and locates the sheet which has the same name as the agents computer name and then makes this visible and the rest will stay veryhidden. This is to make it secure and ensure that someone can't just unhide it.

Then when it closes a macro runs that puts everything except the welcome page to veryhidden again.

The problem is that i'm guessing if someone opens it, works a bit, then saves without exiting. The next person that opens it will not get only the welcome page but get whatever the previous agent saved and their work will then be available to others.

Is there any work around anyone can think of that can make this work?
I just need a way for everyone to work in one sheet and make it so that people can't see each others work.

Hope someone can help me out here,
Thanks

Best regards
Christian

 

[dmt32]

Hi,
firstly, it always helps to post any code you have as it will help the forum understand the structure of your data.

My own thoughts would be that sharing a workbook is never a good idea it throws up too many problems. A better approach would be to give each user their own workbook to complete & they submit data to a central database on a shared network drive- this could be another workbook or Access database. Either way, will involve some extensive coding.

A further thought, Microsoft had an excellant template wizard addin (xl2002 I think) that you could connect to a database which may (if still available) assist you - have a look here:Creating a data entry form with the Excel Template Wizard - Excel - Office.com

Hope helpful

Dave