Ignoring a read only in a different document

[Urkrabb]

Hello,
I have two excel documents that I use for project groups to document positive and negative experiences. The first document is a template for the project groups where they make their own copy and use it to enter information through a user form that stores the data on the document as well as the second document. The second document functions as a library where all the information from the different projects gather.
Since the first document enters data into the second I haven’t been able to make the second document read only. This is a bit risky since the users might make changes or loose data.

Is there any way that I can make the second document read only but still allow the first document to add information to it?
I am very new to VBA so please imagine that you are speaking to a very slow child.

I'm thankfull for all the help I can get.

 

[Urkrabb]

I was able to work around the problem so no need for you guys to waste time on solving this for my sake. If someone else encounters a similar problem i used:
Sub .....()
Activesheet.Unprotect
....my code....
End With
Activesheet.Protect AllowFiltering:=True
End Sub