How can I prevent users from linking to other sources in Excel?

Z

Zuni

Is there a way to protect the Excel workbooks so that users cannot create
links to external sources when they enter data?
 
B

Bob Umlas

using the Workbook_SheetChange event you can trap for a [ character in a
formula & not allow it...?
 
B

Barb Reinhardt

Bob,

How would you do this? I'd like to prevent this as well.

Thanks,
Barb Reinhardt

Bob Umlas said:
using the Workbook_SheetChange event you can trap for a [ character in a
formula & not allow it...?


Zuni said:
Is there a way to protect the Excel workbooks so that users cannot create
links to external sources when they enter data?
Click to expand...
Click to expand...
 
Top