How to protect excel's file

[seb30]

Hello everyone,

I saw an excel's file with his vba's code invisible.
How is it possible?
How can I do the same with my files?

Thanks in advance,

Seb

 

[VoG]

In the Visual Basic Editor, Tools > VBAProject Properties > Protection tab. Tick Lock Project for Viewing and enter a password. You will then have to save and re-open the file for the protection to take effect.

Note that Excel is not a very secure application: passwords can be cracked.

 

[seb30]

This is how you protect your file from opening your project in the editor... am I right?
What I saw is: I could go to the project but when I clicked on thisWorkbook for example, I could not see anything.

 

[xenou]

Most likely there was no code in the ThisWorkbook class module. I can only imagine some rare possibility of white font otherwise. The code you are looking for might be somewhere else...

 

[seb30]

Ok, I'll take a look on monday more carefully.

Thanks