Password protected workbook discussion....

chuckles1066

Banned
Joined
Dec 20, 2004
Messages
372
I recently had to deal with some data sent to my company in a password protected workbook.

The data was viewable but not modifiable (effectively read-only) - why, I don't know...........but we needed to manipulate the data and it took literally 20 seconds to save the workbook as a text file and then re-open it in Excel, set where I wanted the field breaks to be and voila.

Any comments on why there's such an easy workaround?

FWIW, this isn't a criticism of Excel, just a genuine observation :)
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Any comments on why there's such an easy workaround?
Because Excel's not a secure environment, not has it ever been marketed as one. Workbook & sheet protection really just keeps honest people honest and 99% of the time, that's good enough.

Smitty
 
Upvote 0
If you can get into the VBA viewer, then the code is very easy to break. If you want to protect the workbook to keep most people from being able to get the information, you need to password protect the vba viewer.
 
Upvote 0

Forum statistics

Threads
1,214,324
Messages
6,118,890
Members
448,854
Latest member
Eduard_Stoo

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