Protecting a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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
 
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
 
Back
Top