Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
Convert excel vba to vb
Name:
Glenn
Email (spam proof):
Email the originator of this post
Date:
Monday, August 01, 2005
Hits:
71
Discussion (Terms and Conditions):
Hi, Hoping for some guidance please. I have written a program in excel. It uses formulas that need macros to run. There is virtually no direct vba. I have discovered that security in hiding the formuals in excel vba is virtually non existent. At the moment I have three types of sheets in the workbook. Input sheets Formula sheets, where all the grunt work happens (very hidden) Output sheets - where the final data appears. To get at the formulas you just need to get pass the vba password and change the sheet properties from very hidden to visible and you have access to all the formulas. I am trying to find a way of stopping this. One possible solutin os converting vab to vb (which I know nothing about) I believe vb lets you compile the program. Do you have a simple example of converting excel vba to vb and then compiling the program so people cant get easy access to the underlying formuals? Or some other solution? Thanks for your help. Regards, Glenn

Sponsored by the best FTP application on the internet: