prtect linked worksheet
 

If it is possible how would I protect a worksheet that is shared and linked
to a number of other files with worksheet. Once it is protected will the
links be able to be automatically update when the protected worksheet is
opened