encription of a sheet in a workbook

[daniellecarr]

Hello,
Could you please tell me if it is possible to encript a sheet in a workbook? I have a workbook (2007) where the one sheet which can be 'played' with pulls from another sheet which I don't want the person to see. I would like to encript this sheet as if I hide it and protect it, one can still highlight the contents and see the data. Is it possible to encript this sheet without doing the entire workbook?
Thank you very much.
Danielle

[abousetta]

It's not clear if you want to encrypt, lock, or hide the sheet. These are three different things. So the do you want the person to:

1) see the sheet but not change anything in it

2) hide the sheet so they can't see it

3) encrypt it so that even if they saw the sheet it would like as if it meaningless random letters/ numbers (theoretically you would also want to hide the sheet as well).

abousetta

[daniellecarr]

Hello Abousetta and thank you so much for replying to my thread. I would want (3). I would want this particular sheet to be hidden and encrypted. It it possible to do this without affecting the other sheets, and would the formula's pulling from this sheet be unaffected?

Thank you so much.
Danielle

[abousetta]

Hi Danielle,

Encryption can be done using a macro that would substitute letters/numbers for another using a cipher. Once the workbook is opened, then the macro would decipher the encrypted sheet so that formulas and other macros can use this data. Once the workbook is set to be closed the macro would encrypt everything again. This would typically require two seperate workbooks (one containing the encryption/ decryption algothrytm) while the other containing the data being encrypted/ decrypted). The idea would be that if someone forcibly opened the workbook while it is encrypted then no information would be easily attained.

Now the hard part is getting this altogether. I have seen it done professionally and there may be publicly available code for this but I haven't seen it yet. The more practical solution would be to 'very hide' the sheet containing the sensitive information so that it can only be opened using vba. This will keep the 'average' user from seeing the data but by no means is Excel made for highly classifed documents.

Hope this helps.

abousetta

[daniellecarr]

Dear Abousetta

Thank you again for you help. I shall use the very hidden command. This should be suffice.

Thanks again and have a great day.

Danielle

[abousetta]

I have prepared a worked example in a previous thread that you might want to take a look at.

Good luck.

abousetta

[daniellecarr]

That helps! Thank you so much!

Danielle