Is there a way to do this without disabing the macros themselves ? I want to send a file to people, but I don't want them messing with the code, and additionally, I don't want their security settings too high, so where they can't view the data either. Are my only options some message boxes the simply "warn"?

Howzit

Does ths link help?

http://www.ozgrid.com/VBA/protect-vba-code.htm

Adam,

Kiwiman's link won't open for me and it might say the same as me.

Go into the code window and Tools and Project Properties and you will see Protection.

That will blokc entry to all code, seems to be like Excel's version of MDE

Edit: Kiwiman's link now opens, my post is a repeat but without the pictures:D

Thanks guys. I can't believe i didn't sift through and figure this out sooner! :)