protect macro from a different users access



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?

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question