Microsoft Excel, protecting formulas and vba code
Posted on 2014-09-25
I have a MS Excel 2010 .xlsm Workbook that I need to make sure to protect\hide the formulas and the vba code, well beyond what Microsoft offers in forms of protection.
The big sticking point up to now has been that this workbook uses Frontline System's Analytical Solver and that has proved to be incompatible with all the compile and/or encryption, 3rd party tools I've tested to protect the formulas and vba code. I've tried LockXLS, DoneEx, XLSPadlock, and SpreadsheetSentry.
All of these have caused issues for Frontline Analytical Solver where it cannot interpret the formulas correctly after they have been compiled and/or encrypted.
I also need to user to be able to enter values in certain input fields and also save copies of the .xlsm file.
I'm looking a total rewrite in the face, so I wanted to check here for any other ideas. A rewrite of this from Excel VBA to .Net would be a huge effort.