Prevent user from editing macro.

M

MrKrich

Is there other way rather than using macro's password to
prevent the other people from editing the macro's code?
 
H

Howard Kaikow

Re-arrange the code so that all but a minimal portion is in a class.
Then compile the class into a VB 6 ActiveX DLL.

In effect, you just have code in VBA that instantiates the class and calls
the code in the class.
If in Excel, you would need wrapper functions to enable functions in the
class to be used as worksheet functions.
 
Top