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
Highlighted
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!

1 Reply
Highlighted
You can set the workbook to read-only recommended and perhaps even add a password to save changes?