Can you encrypt a macro without encrypting the rest of the document?

R

RMZ

I have a Macro that I would like to keep secure (I don't want other
users of this document to be able to view of edit the macro code). I
know I can password protect/encrypt office documents, but this does me
no good. I have a category of users who need to have permission to
edit the document but not be able to view the code or edit the code
behind the macros. Can this be done?
 
J

jaf

Hi,
Open the VBA editor.
Do Tools>VBA Project properties>Select the protection tab.
Check the "lock project from viewing" box and assign a password.
Don't ever forget the password.

John
 

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

Top