Well I've removed the SELECT access from the public role and now users can't see the Stored Procedure code if they try to view the code via Enterprise Manager...
Thanks for the reply Brian but unfortunately that's not the answer my boss will accept~ ='( So I'll have to keep on researching. With regards to a developer who uses Enterprise Manager...