• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel file permission


Dear Sir,
I have VBA based excel file which can be used to send outstanding statement for all customer in single click, now I wanted to give it one friend to use it but I wanted to use that file by that person only if he gives to someone else it should not work because I have spent a money to get it written from VBA writer.
Please advise.

Marc L

Excel Ninja
Hi !​
As Excel does not contain any strong protection except the password at workbook level since Excel 2013 …​
You may add a protection within the code based on the hard disk serial number or on the user name for example​
but anyone can bypass the VBA password protection via a Web search so too easy to remove any protection within the code.​