How do I prevent users from changing macros?

  • Thread starter Thread starter Guest
  • Start date Start date
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).
 
Actually Earl, the VBA Project PW is much harder to crack than worksheet and
workbook PW.

Gord Dibben Excel MVP
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Preventing users from changing macros 3
how to prevent macros in Personal.xls appearing in other workbook 3
Protect macro from stopping 1
prevent user from deleting a tab prevent running macro from menu 5
macro reference changes with filename 1
Prevent filldown 4
problem with macros and protections 5
Protecting a macro 4

Back
Top