I am going to distribute a spreadsheet that contains some macros. Is it
possible to prevent users from being able to access the code in the macros?

Ie. stop them going Tools | Macros | Edit?

Thanks!