You could write it down and hide it under your mattress <g

Maybe you could try putting a password on the VBA project. Right click on
your project, select properties - input a password.

Also, if you put in a dummy parameter, it should not show up in the macros
dialog box - so the user should not be able to access it through the excel
menus.

Sub Test (dummy as string)

End Sub


However, there are programs that can break the VBA project passwords - so
you are unlikely to stop someone intent on getting at it.


"Shu of AZ" wrote:

Is it possible to hide a macro so no one can see what code exists? If so how
do you do it?