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

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
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
 
L

Legacy 51064

Guest
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,021
Messages
5,834,992
Members
430,331
Latest member
Syed Yasir Hannan

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
Top