Excel 2007 : How To Hide/Protect all macros in a worksheet?

[frittob]

I found the trick for putting 'Option Private Module' in the Module ... which removes all Macros from the list of macros ... but they are still visible if you press ALT-F11

How do you hide the macros entirely from prying eyes?

Thanks In Advance

[using Excel 2007]

[JBeaucaire]

In the left panel of the VBEditor, right-click on the VBAProject Properties and set security in there, add a password and save it.

Next time you open the sheet, the project is hidden even if the editor is opened. You will need the password to access it.

[frittob]

Perfect ... Many Thanks