Protect Macros
 

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

Protect Macros
 

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.


"a m spock" wrote:

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

Protect Macros
 

many thanks. works like a charm


"Alan Moseley" wrote:

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.


"a m spock" wrote:

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

Protect Macros
 

On Oct 22, 2:49*pm, a m spock
wrote:
many thanks. works like a charm



"Alan Moseley" wrote:
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.

"a m spock" wrote:

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

- 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