How protect sheet with password that cannot be cracked

stockstradr

New Member
Joined
Feb 24, 2011
Messages
5
As long as I'm posting, I have to ask this question. I'm sure others here have tackled this one!

As many of you know, there are easily-available software/macro app's that will quickly find the password and unlock a password-protected Excel worksheet.

This effectively makes the password Protect sheet function, kinda useless if my goal is to keep hidden all the code and function in cells that I consider my intellectual property.

QUESTION:
Is there any "uncrackable" method where I can hide my cell functions and the password cannot be cracked by any method that is easily available to the "man on the street" who is searching the internet for ways to crack into a password-protected Excel workbook/worksheet? My meaning is that I'm OK with a method that can be cracked by say some experts at the FBI or CIA, but I at least want something at minimum is impenetrable by the vast majority of Excel users and Excel programmers.

Oh, I had better mention that of course I want to allow the user to be able to interact with the cells in the spreadsheet that are unlocked.
 
Last edited:

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Hi and Welcome to the Board.
Short answer is No.
Excel security is fairly weak and can be cracked quite readily.

It is basically designed to keep honest people honest, and that is the majority of average users.
 
Upvote 0
Short answer is No.
Excel security is fairly weak and can be cracked quite readily.

Thank you for the reply. I kind figured that was the case, but at least posting the question on here let's me confirm it, so I don't go spending weeks in vain trying to track down something only to find it really isn't available for Excel.
 
Upvote 0

Forum statistics

Threads
1,214,911
Messages
6,122,198
Members
449,072
Latest member
DW Draft

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