Need Password to protect Work Sheet.

i have a macro enabled excel file which is protected with password but when i email this to my friend he can easily unprotected the sheet without having any password.

How the thing happens i dont know. Can anyone say how can i protect formula and formatting of my sheet.


Thanks in advance


Naharul

Review => Protect Sheet => 4 digit Password with permission to select only unprotected cells.

Please note that I am using Excel 2016. I have mail (via official outlook version) the document to one of my friend (he is using excel 2007). When i reach to him, after downloading the file, he just click on Review=> Unprotect Sheet and no dialog box appeared and the sheet has lost its protection. I am surprised and I have mail the file to some one else who is also using Excel 2007 and the same thing happen. When i am using Pen Drive to transfer the file, its security is sustained.

Please help.

Naharul

Hi,

I can't explain how it happened but could only suggest to compress the file and mail the receiver .Zip file.

If you dont set up a password for the file, you are not protecting the file. If you only set PW at sheet level, anyone can get in and disable that

What was the result of the 2nd post?

Originally Posted by sajib_148

I have mail (via official outlook version) the document to one of my friend (he is using excel 2007). When i reach to him, after downloading the file, he just click on Review=> Unprotect Sheet and no dialog box appeared and the sheet has lost its protection. I am surprised and I have mail the file to some one else who is also using Excel 2007 and the same thing happen. When i am using Pen Drive to transfer the file, its security is sustained.

So a few things here. Anytime something in a file stops working when being sent via email but works using other means of xfer, the likely explanation is the email system is scanning and stripping the files of something. This could be AV software, the mail server, etc. From your explanation of the circumstances, this is likely whats happening...either your email system or theirs could be doing this. This is easy to test, create a sample file with the protection applied, send via whatever email systems is causing the issue, confirm it is a problem in the sample. If so, then send/receive using personal email accounts...if it works the specific email systems originally used are causing the problem.

Next, its important to understand that Worksheet, Workbook and VBA protections is not a means of security, its a means to prevent mistakes. Whats that mean?

Worksheet, Workbook and VBA protection (henceforth called "protection(s)") are not secure ways to prevent anything or safeguard data/IP/etc. They can be easily circumvented by anyone with the ability to do so or 5 mins to Google how. The point of protections is to prevent undesirable changes to aspects of a file, like accidentally over writing a formula or replacing something.

Ok. Finally i got a solution. But one problem is arised. I have used following code in workbook:

Please Login or Register  to view this content.

But the problem is that when I opened the document, Dialog box for unprotect password is asked for. Afte clicking cancel, it goes away. How can i get rid out of this.