how to hide a list of macros without password protection

Padam · Jul 12, 2006

hi,

I need your help to hide a list of macros from excel 2000 and onwards
without using password protection.

Could you help me?

macropod · Jul 12, 2006

Hi Padam,

The simplest way is to prefix them with 'Private', eg:
Private MySub()

Cheers