[Sussex] hard to read excell macro's

ar at f2s.com ar at f2s.com
Fri Apr 7 12:44:40 UTC 2006


> From: "Andrew Guard" <andrew at andrewguard.com>
> OK I do know how to make it diffacult for people to view Excel Macro's
> within Excel (I know they can use OOo to get arond this).  What I want to
> do is make difaculte to read macro. ie it would be
>
> If vvoice> 7 Then
>    voice - (vvoicex - 9)
> End If
>
> in to something like
>
> If x1> 7 Then
> x1 - (E3 - 9)
> End If

If that's all you need what about making a pair of sed scripts to isolate the
variables and replace them?

HTH
Anthony





More information about the Sussex mailing list