VBA Module and password

Question

Hi,

Could you recall me how to protect a VBA module with a password?

Thanks

Answer 1

WLID1966,

Your question of the day.

Open the VBE with the macro of interest displayed in the code window. Then go to Tools/VBA Project Properties/Protection tab. Set your password as desired. But, be careful, if you forget the password, you're dead.

Hope this helps.

John

Answer 2

Thanks one more time John!

Answer 3

WLID1966,

You're welcome and thanks for the feeback.

John