Protecting a macro

[Guest]

I am going to distribute a spreadsheet that contains some macros. Is it
possible to prevent users from being able to access the code in the macros?

Ie. stop them going Tools | Macros | Edit?

Thanks!

 

[Guest]

Danny,

Yes and strangely enough no!!

You can protect your code by going to the VB editor and then

Tools|VBProject properties|protection
lock project for viewing and apply a password..
That's the Yes bit

The No bit is because the protection is pretty flimsy and cheap commercial
software can remove the passowrd.

Mike

 

[Guest]

You might make the Extra Macro option HIDE
and turn off ALT-F11
Download add-in James 2007 from www.allocator.nl
and check Maintenance option Macro.

 

[Guest]

Great, thanks Mike.

The problem was that one of my Macros does an unprotect then a re-protect of
the worksheet, and therefore I have to specify the unprotect password. I
wanted to stop users from viewing the code and hence obtaining the unprotect
password.

Is the worksheet protection password just as easily cracked as the macro
protection?

Thanks again, Danny

 

[Gord Dibben]

Worksheet protection is more easily broken than is VBAProject protection.

See John McGimpsey's site for more info.

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


Gord Dibben MS Excel MVP