lock macro from users

[venkman]

I'd like to lock the macro code in a workbook (preventing users from changing or possibly viewing the macro code), but allow people to change the data on the sheets contained within the workbook. How do I do this? It does not need to be really secure, just annoying enough to discourage users from editing the macros. I have no desire to prevent the highly-motivated.

-Venkman

 

[SBendBuckeye]

Depending upon what you are doing with your macros, you can hide them from the users entirely by passing a parm to the macro. For example Sub Macro1() will show up in the Tools, Macro list. But if you change it to Sub Macro1(pvarDummy As Variant) it will NOT show up in the list at all because you can't pass paramaters to macros.

Obviously, this approach will only work if you can fire the macros from events automatically. There may be other ways as well.

Good LucK!

 

[acron]

You can protect your VBA code from being viewed or edited.

From the VB editor menus select Tools, VBAProject Properties and select the Protection tab. Then check Lock project for Viewing and enter a password (and confirm).

Save the workbook, close it and re-open and you should find that you cannot edit the code unless you have a password.

A.C.