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.