Protect Macros

[a m spock]

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

 

[Alan Moseley]

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

 

[a m spock]

many thanks. works like a charm

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.

 

[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