How to prevent broken links?

[Guest]

I guess this is more of a Windows (XP) question, but is there a way to
prevent a workbook (to which others have links) from being deleted, moved, or
edited?

 

[Dave Peterson]

Put it on a readonly shared drive. You'll probably need some help from your IT
folks--remember to only ask for permission to read/write/delete for you and your
trusted coworkers.

But ask for readonly permission for everyone else.

 

[NickHK]

Set file attributes and folder permissions in Windows.
Excel has no way to control that if the WB is not open already, although it
can Workbooks.Open FilePathName, ReadOnly=True.

NickHK