How do I prevent users from changing macros?

E

Earl Kiosterud

JimKing,

You can lock the project (Tools - VBAProject Properties) - Protection tab -
Lock project for viewing. The password algorigthm it uses is likely no more
secure than other passwords in Excel, but will keep out the mildly curious).
 
G

Gord Dibben

Actually Earl, the VBA Project PW is much harder to crack than worksheet and
workbook PW.

Gord Dibben Excel MVP
 
D

Dave Peterson

Many people make their living by writing code. If they (and others) choose to
try to protect their intellectual property, why should you have access to it?

Even if you say this is for your own project, how would anyone know if that's
true?
 
Top