Protect Macro from Edit
 

How to use a password to protect my Macro that can be Run
only by others but not Edit?

Protect Macro from Edit
 

Hi
- goto the VBA editor (ALT + F11)
- right-click on your project name and choose 'Properties'
- enter a password in the appearing protection dialog

--
Regards
Frank Kabel
Frankfurt, Germany


Bin wrote:
How to use a password to protect my Macro that can be Run
only by others but not Edit?

Protect Macro from Edit
 

Hi Bin!

In the VBE Project Explorer select the project then:

Tools VBA Project Properties Protection
Give and confirm password

Don't forget the password as they are more difficult to crack.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.