Protect Macros

A

a m spock

How do I prevent someone to whom I make a workbook available from editing my
macros.
 
A

Alan Moseley

Go to the properties of your Module code, click on the Protection tab and
password protect it.
 
A

a m spock

many thanks. works like a charm


Alan Moseley said:
Go to the properties of your Module code, click on the Protection tab and
password protect it.

--
Alan Moseley IT Consultancy
http://www.amitc.co.uk

If I have solved your problem, please click Yes below. Thanks.
 
M

Madiya

many thanks. works like a charm







- Show quoted text -

a m spock,
A word of caution.
Pl note that excel and vba security is not reliable.
Anyone who is determined to break in can do so very easily.
There are lot of tools available on net. Jus google it.
It will only stop a novice and ignorent users.
Regards,
Madiya
 
Top