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

tapoo

New Member
Joined
Oct 16, 2017
Messages
2
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.
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
The short answer is no - Excel's protection is really not that strong.
 
Upvote 0
Then, Review -> Protect Sheet or other things is of no work..

Anyone can google and break the password....

Wow.....

BTW, thanks for reply....
 
Upvote 0
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?
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,194
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top