Prev: Code in a macro to branch to another macro?
Next: Graphing a bounded region with a twist?
From: ankur on 24 Apr 2010 11:09
I am working on a excel vba program where I'm utilizing a Userform
with command, combo-list... buttons.

The program basically asks for a patient's information (gender,
height, weight..). Upon the 'run' command, all the data is calculated
for respiratory-type research on the patient data. The results are a
graphical chart on sheet1 and the raw data on sheet2. Here's what I'd
like to do.

Once the user runs the program, I placed another command button - save
as, which appends the username, gender, and date.

What I'd like is for the Saved results file be in a format where the
user cannot access the vba code. Maybe the system produces a pdf file
with the data and the chart on page 1 and 2?
From: ozgrid.com on 24 Apr 2010 21:56
Protect the VBE
http://www.ozgrid.com/VBA/protect-vba-code.htm



--
Regards
Dave Hawley
www.ozgrid.com
"ankur" <an01digitalservices(a)gmail.com> wrote in message
news:205a51ba-1bc3-49f4-a1fc-5300369a1e89(a)c20g2000prb.googlegroups.com...
>I am working on a excel vba program where I'm utilizing a Userform
> with command, combo-list... buttons.
>
> The program basically asks for a patient's information (gender,
> height, weight..). Upon the 'run' command, all the data is calculated
> for respiratory-type research on the patient data. The results are a
> graphical chart on sheet1 and the raw data on sheet2. Here's what I'd
> like to do.
>
> Once the user runs the program, I placed another command button - save
> as, which appends the username, gender, and date.
>
> What I'd like is for the Saved results file be in a format where the
> user cannot access the vba code. Maybe the system produces a pdf file
> with the data and the chart on page 1 and 2?

 | 
Pages: 1
Prev: Code in a macro to branch to another macro?
Next: Graphing a bounded region with a twist?