Encoding-Decoding

Hi Team,

Very good morning to all..Like am having a excel sheet which has N number of cells which cells contails data and numbers and formulas..By using macro how i can first Encode the workbook contents and then decode the workbook by using the same password.

Any assitance appreciated..

Thanks,
Lakshmanan

Hi Shg,

Thank you so much for the responce.That is OK.But my requirement is by using excel macro i need to encode the workbook contents and after Decode the contents of the excel workbook contents...after encoding other users should be able to read the contents (Encoded contents).But should not be able to understand the contrents...If the user or other user After entering the Decode password the user should be able read/Modify the originala content of the workbooks..

HI can anyone look into this and help me out...

Why? That's so much more insecure -it's a huge amount of work and for no practical benefit since anyone could simply read the code and undo it.

Thanks Kyle123,

But as per your concern is this more insecure ...i understood..But we need to send and receive more secure contents .So only am wondering..If im put password means ..people will get the password from collegues and read/Modify the data easily...But is this possible through excel VBA..Let me know for any questions..

Thanks

Can anyone pls look into it and help me out

people will get the password from collegues and read/Modify the data easily

And how would a macro resolve this?

Hi Kyle123,

Thanks for all the response and i got the solution.I have tried with my tool and it is working fine for me.Im able to encrypt and decrypt the workbook contents using excel vba macro.

Lakshmanan