Protecting My Macros

G

Greegan

I want to protect my workbook so that anyone using my workbook will be able
to run the macros but not view the editor. Is this possible? and how do i
have this done?
I've played around with the protect workbook and such but nothing seems to
prevent the viewing, and in turn USING my macros.

G
 
D

Dave Peterson

Inside the VBE
Select your project
Tools|VBAProject Properties|Protection tab

Give it a memorable password and save, close, reopen your workbook to test.

That said, this password isn't very strong. It can be broken in seconds. But
it will keep out most.
 
Top