Is it possible to protect just one module in Excel 2002.
As VBA project properties seems to lock the entire lot,
including the ability to create/record a new macro without
first entering the password. Which I'd rather not
circulate.

Sub HideMe ()
ThisWorkbook.Modules("Module1").Visible = False
End Sub

Is in the knowledge base for previous versions and sounds
like what I want but it doesn't seem to work in 2002.

Any Help Appreciated

Paul