Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

stop staff cracking excel workbooks 2

Status
Not open for further replies.

thelos

Technical User
Aug 1, 2005
17
GB
hi,

i work for a small offshore company we use a excel workbook offshore, we have multiple locked down cells within the book. however the offshore staff have been using an unlocking excel add-in called password.XLA to unlock the book. is there any way of stopping these types of unlocking tools???
 

i dont believe there is a way to stop this, excel has not been developed as a secure application, the security in excel is to avoid errors more than deny access. i am not aware of a way, but you could limit the access to certain usernames if that would help?
 
nope

Excel should not be used to store sensitive data

End of

Even if you block access to .xla files, the code to crack a worksheet password is laughably easy and its not too difficult to crack a workbook password...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
what are the locked down cells used for ? is it formulas or data ?

Chance,

F, G + yeah reached 50
 
Deny them access to the file in the OS. Or are you saying the owner of the file is changing his own data?


Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top