+ Reply to Thread
Results 1 to 3 of 3

File gets locked by users that only have permission to read.

  1. #1
    Registered User
    Join Date
    02-11-2013
    Location
    Norway
    MS-Off Ver
    Excel 2010
    Posts
    1

    Unhappy File gets locked by users that only have permission to read.

    Hello

    A user in our company has a document on a shared drive in our domain. It's using the protect feature which means that you'll have to type username/password before you're allowed to edit the document. The problem is that users who only want to view the document will cause it to lock, and then you can't edit it before they close it.

    I thought that sharing the document would solve this issue, but when I tried to it said that Visual Basic features would not work which basically makes the document useless so that's not an option

    And so now I am out of ideas, tried to Google but I was unsuccessful.

    Help!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,000

    Re: File gets locked by users that only have permission to read.

    You need two passwords ... a password to open and a password to modify ... and, ideally, recommend opening as "read only".

    If you provide the password to open but not the password to modify (click on Read Only), it will open in read only mode.


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: File gets locked by users that only have permission to read.

    Hi odmjun,

    welcome to the forum.

    What if you open first and then they open as "read only" - would be ok, I guess
    Try it once and share the result.

    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com

+ 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