Hi,

I have created a 2 files which are linked to each other on a network and usually when I change some data on my "master file" I want the other file to get updated by choose Data-Edit links-Update values.
The problem is that the file is protected and thus it does not work if one would like to update values but I still want the file to be locked so that no one can change the values or formulas in it.
I know it can be done with VBA but I don't know how and what to write.

I had the same issue with updating with a macro but for that I figured out the solution using "ActiveSheet. Unprotect..." You get the point but what to write so that the link can be updated and the sheet is protected at the same time ?

Can you geniuses help me