Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 705
  • Last Modified:

Microsoft Excel, protecting formulas and vba code

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.


Thanks,
Jon
0
JBM9966
Asked:
JBM9966
3 Solutions
 
RayData AnalystCommented:
If you're that serious about protecting what's 'under the hood', then sadly a programmatic method is the only way I know about.  You can hide things from most users fairly easily, but to truly lock it down 100% without losing functionality...I have never seen it implemented.  Sorry.

Maybe other experts could weigh in on some kind of 'bullet proof' protection?
0
 
JBM9966Author Commented:
Thanks, I've been reading up a bit on Excel 365 Online and SharePoint 2013, it sounds like you can secure workbooks in a more enterprise type manner, but I'm not sure it would allow me to protect\hide formulas and vba, while also allowing the user to enter into some input cells on the workbook.

Jon
0
 
Glenn RayExcel VBA DeveloperCommented:
Excel password protection is not bombproof; there are plenty of crackers and tips online for hacking.

That said, you can do a couple of things to protect from regular users.
1) With Sheet protection, limit entry and cell selection to unlocked cells only:
sheet protectionThis will prevent users from clicking on cells which likely contain formulas and therefore, won't be able to see or edit them.
2) With VBA, protect your project (VBA Menu: Tools, VBAProject Properties)
VBA protectionIt probably goes without saying, but use a different password for this than for sheet protection!

-Glenn
0
 
Rory ArchibaldCommented:
FYI, the web apps won't run VBA, which sounds like it would be an issue.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now