Hi guys,

I have had a lot of help on here and have a reasonably functional system. Recently we have moved it to be used on the network and I am having some issues with people opening duplicates of certain files... I will explain further...

I have all my code in a 'master' file so that it does not duplicate on each of 100+ files which need the information contained. When someone opens one of the 100+ files, it automatically loads the master. If someone tried to open the same 100+ file as someone else, they are automatically warned because the file is already open. However, if someone tries to open a different of the 100+ files it opens ok and proceeds to open the master as well, only it opens it as read only. The problem comes because I automatically save the master and, because it is now read only, I get a mess where I have to save as something else or cancel repeatedly to get away from it. I want to avoid this and I am looking for suggestions...

My ideas...

1) Some sort of 'if read only' on the master such that, when it opens and discovers it is read only, it then prompts to say so and automatically closes the master and 'daughter' (for want of a better term) file, without saving. The problem I can see with this is that the daughter could be any one of several hundred options so how do I make sure only master and daughter are shut and not any other excel files which I previously had open.

2) Some sort of a clause which I can put in place 'if read only'. In other words, upon closing down the file, excel identifies that it is read only and does NOT carry out the usual 'save' procedure. I could use then a similar clause to ensure that my normal operations which allow me to change the master are disabled.

I think that (2) sounds like a cleaner solution so can anyone tell me what code I should use to do an 'if not read only' do 'x' (my existing code) else do 'y' (i.e. don't save or dont allow mods)?

Many thanks

Adam