+ Reply to Thread
Results 1 to 2 of 2

Password protected workbook continues to be locked up by users

  1. #1
    Registered User
    Join Date
    03-12-2015
    Location
    Tucson, AZ
    MS-Off Ver
    MS Office 2010
    Posts
    1

    Password protected workbook continues to be locked up by users

    I have a question that I am curious if anyone has ever come across. I'm not sure if this is an IT question or an excel question. But I figured I would start here...

    I have a large workbook (Excel 2010, .xlsm) that I keep in a shared file on our network. The file is password protected and only able to be opened as 'read only'. No other users know the password, so no one else should be able to open the file for editing. However, there have been a few cases where I try to open the file myself and I immediately get a notification that the file is locked by 'another user'. Each time that has happened I have had to have my IT group look on the server to see who the person is, which I then go and talk to, and find out that they only accessed the file as read only, and in all cases the didn't have the file currently open. It somehow got "hung up" on their profile. I have to have IT kill the file they show as open so I can access it.

    Is there possibly something in the way I have saved or secured the file that could be causing this? Or is there a different way I can secure the file without having to password protect it like this? It's not necessarily for true security reasons, it's more to prevent changes from being made accidentally. It doesn't happen all the time. The file is probably accessed 100+ times a week and it usually only errors out like this about once a week.

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Password protected workbook continues to be locked up by users

    If it's more as a layer of protection from accidental change, then you can put a PW in code in ThisWorkbook module.

    Please Login or Register  to view this content.
    If you use a specific network login, you can use that too and then it's not a PW but just you.

    Check your username by going to the immediate window (Cltr+G) and type ?Environ("username")

    That's you.

    Please Login or Register  to view this content.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

+ 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. [SOLVED] VBA to allow users to delete specific rows with locked cells on protected sheets
    By JT12345 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-13-2015, 02:46 PM
  2. Replies: 2
    Last Post: 11-17-2014, 04:28 PM
  3. [SOLVED] Password array to open all password protected workbook in a folder
    By rename in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-07-2012, 05:06 AM
  4. My password-protected vba code is locked for viewing...
    By Stu M in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-25-2009, 04:51 AM
  5. Replies: 2
    Last Post: 07-13-2006, 08:05 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