Hi Mario

You can place Private before each sub you want to hide
Private Sub test()

Or add this at the top of the module for all the macro's
Option Private Module

This way you don't see it in the macro list (Alt-F8)


You can Protect your project in the VBA editor

Alt-F11
In the menubar ToolsVBA project properties
See the protection tab

This way they can't see or edit your code


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Mario" wrote in message ...
Is there a way to Hiding/Protecting the code of macro and
worksheet procedures from the users viewing it. Can it be
made pass-word accessible only.