One of the managers and I are currently working out of the same worksheet and I need to put in a single user edit so that when we are in it neither of us can edit it whilst the other is in so we do not end up losing our work. How can I set up a single user lock so that only the first person in the file can edit but once they come out a prompt will then appear on the 2nd users screen informing them that they are able to edit?
