Forum Discussion
Sharing Macro-enabled excel workbook to be used as a calculation tool
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, an...
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.
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.