Results 1 to 5 of 5

Thread: Need to know about locking excel file so that Password can't be broken by VBA
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2017
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Post Need to know about locking excel file so that Password can't be broken by VBA

    I have very basic knowledge on Excel. I am using Excel 2010.

    I password lock excel sheet from Review=> Protect Sheet.

    But i find in Google that it can be broken easily by putting a code in Alt+F11 window.

    Is there any way to stop entering code in Alt+F11 window?

    Or any other way to stop unlocking my locked Excel Sheet?

    Please, guide Me..

    Thanks in advance.

  2. #2
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,803
    Post Thanks / Like
    Mentioned
    48 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Need to know about locking excel file so that Password can't be broken by VBA

    The short answer is no - Excel's protection is really not that strong.

  3. #3
    New Member
    Join Date
    Oct 2017
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need to know about locking excel file so that Password can't be broken by VBA

    Then, Review -> Protect Sheet or other things is of no work..

    Anyone can google and break the password....

    Wow.....

    BTW, thanks for reply....

  4. #4
    New Member
    Join Date
    Oct 2017
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need to know about locking excel file so that Password can't be broken by VBA

    I didn't know people can bypass protection through VBA. So there really is no way to protect an Excel sheet from editing? What about using the worksheet.protect method?

  5. #5
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    11,065
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Need to know about locking excel file so that Password can't be broken by VBA

    Quote Originally Posted by Zenru View Post
    I didn't know people can bypass protection through VBA. So there really is no way to protect an Excel sheet from editing? What about using the worksheet.protect method?
    The worksheet protect method is the same as what is being done manually via review. If anyone with a good knowledge of Excel wants to bypass the workbook or worksheet security then they will.
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, RoryA addin (Win & Mac) or Borders-Copy-Paste

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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