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

[tapoo]

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.

 

[RoryA]

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

 

[tapoo]

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

Anyone can google and break the password....

Wow.....

BTW, thanks for reply....

 

[Zenru]

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?

 

[MARK858]

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.