PDA

View Full Version : Encrypt Decrypt Excel cells/ colums



dunkin
10-06-2016, 07:35 AM
Hi Guys,

I need help to encrypt and decrypt classified data. there is total 10 cells, I have to encrypt 4 columns and lock them. 6 columns for 3rd party. Is there in formula? I don't know how to solve this problem?

SamT
10-06-2016, 08:48 AM
You need the encryption software and the password from the client.

dunkin
10-06-2016, 08:55 AM
what kind software is best, client using only excel

YasserKhalil
10-06-2016, 08:57 AM
Hello dunkin
Have a look at this link
http://yasserkhalilexcellover.blogspot.com.eg/2016/10/encrypt-and-decrypt-function.html

SamT
10-06-2016, 11:12 AM
VBA Express does not help with password or decryption breaking.

Paul_Hossler
10-06-2016, 12:39 PM
Hi Guys,

I need help to encrypt and decrypt classified data. there is total 10 cells, I have to encrypt 4 columns and lock them. 6 columns for 3rd party. Is there in formula? I don't know how to solve this problem?

Some more information will be helpful

'classified data' as in government stuff?

'classified data' as in "I don't want anyone else to see it"

How secure to you want it?

dunkin
10-06-2016, 12:42 PM
government data

Aussiebear
10-07-2016, 01:45 AM
Have a look at this link
http://yasserkhalilexcellover.blogspot.com.eg/2016/10/encrypt-and-decrypt-function.html

Any chance of converting this to english?