Mike,

In the VBE project explorer window, select your project. Then right click,
and select Properties. There is a Protection tab to do what you want.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mike" wrote in message
...
I've seen it done before but can't find this option.

I just want to protect my VBA from prying eyes without putting a password
on
the entire file and protecting each sheet.

Any help would be great!

Thanks,
Mike