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.

Greegan wrote:

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

--

Dave Peterson