Protect Macro from Edit

B

Bin

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

Frank Kabel

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

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top