Protecting Macros

[wmtsub]

How can I protect my macros from editing or even viewing?

 

[Fluff]

Password protect them, although it's not totally foolproof.
Right click the project in the Project window > VBAProject Properties > Protection > check the box & enter password.
Save, close & reopen the workbook

 

[wmtsub]

Thanks, Tried that and re-opened the wb. Went tot teh macro and it asked for my PW. I did not enter it but was able to modify and save it anyway.
Is ther another option?

 

[Fluff]

Did you select "Lock project from viewing"?

 

[wmtsub]

yes I did

 

[Fluff]

In that case did you set a password?

 

[wmtsub]

yes

 

[Fluff]

Then if you try to view the code & don't enter a password it should not let you in.
If it is letting you in to the code, are you sure you protected the correct workbook?

 

[wmtsub]

Yes. Just will not work. That is why I was looking for an alternative system.