Hi,
I have several workbooks used by my team and I have a master copy as an overview. Currently, they update their individual sheets and then copy and paste it into the master copy. I want to set it up so that they can do it using a macro - that's straightforward enough I know, however as a number of people have access to the master copy there is the possibility that it'll be open by someone else at any given time. I therefore need a code that will ignore the read only alert and cancel the paste process. Any ideas?
I have several workbooks used by my team and I have a master copy as an overview. Currently, they update their individual sheets and then copy and paste it into the master copy. I want to set it up so that they can do it using a macro - that's straightforward enough I know, however as a number of people have access to the master copy there is the possibility that it'll be open by someone else at any given time. I therefore need a code that will ignore the read only alert and cancel the paste process. Any ideas?
