protecting macros for a protected sheet

[Jon]

does anybody know the best way to protect macros so they cannot be
viewed by anyone using a protected sheet.

 

[JE McGimpsey]

Compile them as a COM add-in.

Macro protection is incredibly easy to bypass. Anyone with the ability
to find these groups can find ways to get around XL's various
protections.

 

[Jon]

COM add in's are completely foreign to me. I have never done that
before. Is there some kind of a link to some "how to's" that you know
of?

 

[JE McGimpsey]

There are thousands of links you can Google. Here's one from MSDN:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno2k3ta
/html/odc_OFCallVBAFromAddin.asp