+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Zuni
    Guest

    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?

  2. #2
    Bob Umlas
    Guest

    Re: 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" <[email protected]> wrote in message
    news:[email protected]...
    > Is there a way to protect the Excel workbooks so that users cannot create
    > links to external sources when they enter data?




  3. #3
    Barb Reinhardt
    Guest

    Re: 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" <[email protected]> wrote in message
    > news:[email protected]...
    > > Is there a way to protect the Excel workbooks so that users cannot create
    > > links to external sources when they enter data?

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1