stop staff cracking excel workbooks 2

[thelos]

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???

 

[shVBA]

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?

 

[xlbo]

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

 

[Chance1234]

what are the locked down cells used for ? is it formulas or data ?

Chance,

F, G + yeah reached 50

 

[abaldwin]

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.