+ Reply to Thread
Results 1 to 3 of 3

How to lock a worksheet with linked data?

  1. #1
    Registered User
    Join Date
    03-13-2014
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    30

    How to lock a worksheet with linked data?

    I have an Excel worksheet with data linked from an Access database. I want to lock it so that no one can edit the Excel worksheet but yet the data will still update from Access. I can't figure out how to do both.

    Thanks!

  2. #2
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: How to lock a worksheet with linked data?

    Would a password help? If those without a password could only open the file read only it would still update from Access, but they could not save any changes they make. That may not be what you want as they could still edit the read only version they have open and save a copy for themselves, but it would keep the original intact.

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: How to lock a worksheet with linked data?

    Try Protecting it via coding by enabling the UserInterFaceOnly as True so that users manual access/entries can be restricted.

    UserInterFaceOnly will get vanished once the workbook is closed and re-opened. You have to initiate the protection via coding every time on by adding the code in Workbook open event


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Row wont lock on sort from linked column on another sheet
    By stevesince1981 in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 10-03-2013, 01:09 AM
  2. Lock/Unlock Macro for Entire Row linked to Color-Changing Shape
    By sumkynduvstrange in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-26-2013, 10:27 AM
  3. How to lock or link a dependent row of data together during a sort on another worksheet?
    By 97FLHRrider in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2012, 12:54 PM
  4. Replies: 1
    Last Post: 05-22-2009, 11:30 AM
  5. Formulas using data in a linked worksheet
    By Excellist in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-18-2008, 06:16 PM

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