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 :)
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,536
Messages
5,572,774
Members
412,482
Latest member
arooshrana2
Top