How to prevent broken links?
 

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?

How to prevent broken links?
 

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.



Allen_N wrote:

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

How to prevent broken links?
 

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

"Allen_N" wrote in message
...
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?