ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I prevent users from linking to other sources in Excel? (https://www.excelbanter.com/excel-worksheet-functions/75497-how-can-i-prevent-users-linking-other-sources-excel.html)

Zuni

How can I prevent users from linking to other sources in Excel?
 
Is there a way to protect the Excel workbooks so that users cannot create
links to external sources when they enter data?

Bob Umlas

How can I prevent users from linking to other sources in Excel?
 
using the Workbook_SheetChange event you can trap for a [ character in a
formula & not allow it...?


"Zuni" wrote in message
...
Is there a way to protect the Excel workbooks so that users cannot create
links to external sources when they enter data?




Barb Reinhardt

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

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

Thanks,
Barb Reinhardt

"Bob Umlas" wrote:

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


"Zuni" wrote in message
...
Is there a way to protect the Excel workbooks so that users cannot create
links to external sources when they enter data?






All times are GMT +1. The time now is 11:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com