Is there any way I can secure my macros so that no one else can edit o
even see them without a password?


Thank

--
monkeyma
-----------------------------------------------------------------------
monkeyman's Profile: http://www.excelforum.com/member.php...fo&userid=3584
View this thread: http://www.excelforum.com/showthread.php?threadid=55636

Hi Monkeyman,

In the VBE,

Tools | VBAProperties | Protection | Lock Project For Viewing |
Insert password | OK

Now, save, close and re-open the file.

Note, however, that Excel security is very weak and may readily be
surmounted,


---
Regards,
Norman



"monkeyman" wrote
in message ...

Is there any way I can secure my macros so that no one else can edit or
even see them without a password?


Thanks


--
monkeyman
------------------------------------------------------------------------
monkeyman's Profile:
http://www.excelforum.com/member.php...o&userid=35844
View this thread: http://www.excelforum.com/showthread...hreadid=556368

Thanks very much! If there's any way of making it more secure I'd lik
to know but that's a good start

--
monkeyma
-----------------------------------------------------------------------
monkeyman's Profile: http://www.excelforum.com/member.php...fo&userid=3584
View this thread: http://www.excelforum.com/showthread.php?threadid=55636

Hi MonkeyMan,

I think that you have to appreciate that Excel is intrinsically and
inherently insecure.

You may, however, care to follow previous threads on this oft raised
question:

http://tinyurl.com/ekyxe


---
Regards,
Norman



"monkeyman" wrote
in message ...

Thanks very much! If there's any way of making it more secure I'd like
to know but that's a good start!


--
monkeyman
------------------------------------------------------------------------
monkeyman's Profile:
http://www.excelforum.com/member.php...o&userid=35844
View this thread: http://www.excelforum.com/showthread...hreadid=556368

How can you overcome the password? I have a couple of documents that
can't edit of because I can't remember the paswords. They are m
work...hence the security isn't so strong!!

--
phil200
-----------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...fo&userid=3509
View this thread: http://www.excelforum.com/showthread.php?threadid=55636

Hi Phil,

See:

http://www.mcgimpsey.com/excel/removepwords.html


---
Regards,
Norman



"phil2006" wrote in
message ...

How can you overcome the password? I have a couple of documents that I
can't edit of because I can't remember the paswords. They are my
work...hence the security isn't so strong!!!


--
phil2006
------------------------------------------------------------------------
phil2006's Profile:
http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=556368