You can place Private before a sub like this
Private Sub test()
Or add this at the top of the module
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 XL2002 SP-2)
www.rondebruin.nl
"SanMartin" wrote in message ...
Can anyone tell me how to hide VBA code in a excel
applicatiuon so that users can't see it or modify
it.