Sharing Macro-enabled excel workbook to be used as a calculation tool

%3CLINGO-SUB%20id%3D%22lingo-sub-1448043%22%20slang%3D%22en-US%22%3ESharing%20Macro-enabled%20excel%20workbook%20to%20be%20used%20as%20a%20calculation%20tool%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1448043%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20question%20about%20which%20way%20would%20the%20wisest%20to%20share%20a%20macro-enabled%20workbook%20that%20has%20quite%20a%20lot%20VBA-code%20in%20it.%20Is%20there%20a%20wise%20way%20to%20protect%20and%20keep%20the%20original%20workbook%20the%20same%2C%20and%20give%20a%20permission%20for%20the%20user%20to%20download%20a%20new%20copy%20of%20the%20original%20file%2C%20and%20then%20have%20edition%20rights%20in%20this%20new%20copied%20file%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20goal%20is%20to%20make%20sure%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Users%20download%20(''Save%20as'')%20the%20original%20template%20workbook%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Users%20keep%20the%20original%20template%20workbook%20with%20all%20the%20macros%20and%20formatting%20the%20same.%20This%20original%20workbook%20resides%20inside%20a%20shared%20folder.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3.%20Users%20can%20do%20whatever%20with%20the%20tool%2C%20when%20it%20is%20saved%20as%20a%20new%20file%20on%20their%20personal%20computer.%20Changes%20in%20this%20file%20don't%20change%20the%20original%20template%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1448043%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Adoption%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a question about which way would be the wisest to share a macro-enabled workbook that has quite a lot VBA-code in it. Is there a wise way to protect and keep the original workbook the same, and give a permission for the user to download a new copy of the original file, and then have edition rights in this new copied file?

 

 

My goal is to make sure:

 

1. Users download (''Save as'') the original template workbook 

 

2. Users keep the original template workbook with all the macros and formatting the same. This original workbook resides inside a shared folder. 

 

3. Users can do whatever with the tool, when it is saved as a new file on their personal computer. Changes in this file don't change the original template file.

 

Thanks for the help!

3 Replies
You can set the workbook to read-only recommended and perhaps even add a password to save changes?
A lot depends on your file.
There are ways to protect the sheet but they are breakable I hear.
If your intention to protect the file is to protect your intellectual rights, then it is good to look for premium applications that encrypts excel files.
If your team ain't that smart, then there are a few simple ways:
1. I often protect my sheets in such a way, that the user can only select and edit limited fields.
2. I also password protect VBA
3. I also protect the workbook besides sheets.
Since you mentioned it is a calculation tool, all you need is to make only those cells unprotected and selectable that is for user input. I would also use text box to display the answer indirectly, which prevents the user from tampering.

If you want to restrict users, you can apply read only and opening passwords in the advanced save options.

Then again, excel was not designed for user data privacy protection. It is merely designed to protected unwanted edits.