VBA code - protect - using vba code

[jokerper]

Hi,

Is it possible to set a vba protect code with the lock for viewing with vba code.

So unprotect/protect your vba code inside the vba code?

 

[wolverineb]

Welcome.

This is covered here, I think:

http://www.mrexcel.com/archive/VBA/12429.html

 

[jokerper]

It didn´t work on my excel 2007. Some of the code worked but it didn´t set the password. It closed my code windows and put in some text in the spreadsheet like + test test