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



"Larry Graff" wrote in message ...

I have an application in Excel that contains several
macros for an end user. I don't want the user to be able
to modify or see the macro code. Can someone tell me how I
can hide the macros from being viewed and modified?

Thanks In Advance.

Larry Graff