Previous in Forum: LabVIEW   Next in Forum: SolidWorks PDM Vault Question
Close
Close
Close
2 comments
Rate Comments: Nested
Associate

Join Date: Mar 2007
Posts: 35

Omitting Access to VBA+Excel Sources

08/18/2009 3:17 AM

Hi

I use Excel +VBA to write codes and create softwares related to my calculations. Does anyone know how I can change the appearance of my softwares, so that no one would be able to access its source and equations? I want to give my softwares a neat look in the design mode so no one would tell this has been done in Excel.

Thanks

Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.
Participant

Join Date: Aug 2009
Posts: 1
#1

Re: Omitting Access to VBA+Excel Sources

08/19/2009 6:46 AM

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

Register to Reply
Anonymous Poster
#2

Re: Omitting Access to VBA+Excel Sources

08/24/2009 5:17 AM

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

Register to Reply
Register to Reply 2 comments

Previous in Forum: LabVIEW   Next in Forum: SolidWorks PDM Vault Question

Advertisement