+ Reply to Thread
Results 1 to 4 of 4

Password protected Excel Shared File unlocked automatically

  1. #1
    Registered User
    Join Date
    07-30-2019
    Location
    Dhaka Bangladesh
    MS-Off Ver
    2013
    Posts
    2

    Question Password protected Excel Shared File unlocked automatically

    Dear All,

    Seeking for your kind help!

    I've created one excel file (2013) where I've given access to multiple people by different password. Everything is perfect like multiple people can access at the same time by their own password, track changes also working properly.

    But the problem is just after some days (4 to 5 ) i'm observing some of the fields are becoming unlocked automatically. Means it's not asking for password. I'm the only person have admin password.

    Would you please help me what is the root cause of the said issue and how can I solve it permanently?

    Regards
    Uzzal

  2. #2
    Banned User!
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,187

    Re: Password protected Excel Shared File unlocked automatically

    It's not that some are unlocking automatically, more likely that a user has unlocked them with their password and not locked them again afterwards.

  3. #3
    Registered User
    Join Date
    07-30-2019
    Location
    Dhaka Bangladesh
    MS-Off Ver
    2013
    Posts
    2

    Re: Password protected Excel Shared File unlocked automatically

    Dear Mr. Jason,

    Thank a lot for your response!

    It doesn't need to lock again after putting some information. It'll be automatically locked/ protected after logging off or save.

    Regards
    Uzzal

  4. #4
    Banned User!
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,187

    Re: Password protected Excel Shared File unlocked automatically

    So you have a BeforeClose event in the ThisWorkbook vba module to re-apply the protection?

    A user not allowing macros to run or an error in another procedure that is leaving events set to false are just 2 things that could prevent your code from running and reapplying the protection.

+ 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