Omitting Access to VBA+Excel Sources

The link below may be of some use to you. This web site is quite good for hints and tips for excel VBA

http://www.ozgrid.com/VBA/protect-vba-code.htm

Your best bet is to use MS access

Not sure if you have tried MS access

you already know vba

the formula's you use in excel

can be created on a MS access form

when you are done you can compile MS access

with passwords and user rights

and also write code to access the CPU serial number

HD serial Number

date etc to lock any one out from viewing your code

you can use form design to layout the data the with the look and feel

you desire

and you have send key capabilities to start another program

send it what ever and collect it

then remove it and apply your data inside an access table

while you have the MS access form open

Hope this helps

Johnny Flash