Excel Security Considerations
Posted on 2011-03-23
I'm working to finalize a Excel Workbook that I'd like to distribute. However, I'm not certain how to design the security for it. Specifically I'd like to know how to;
1.) Secure the entire workbook from any changes while still allowing all of the worksheets to trade information and calculations.
2.) How to initiate a "global password"
3.) If I lock a spreadsheet, does that mean it cannot update calculations that occur based on links to other worksheets within the same workbook?
4.) What considerations should be used when securing an individual worksheet?
5.) When securing the VB Code and Macros, is protecting the "project" enough?
I know security is not absolute in Excel; however, I'd like to make it rather difficult for someone to hack into the macros or change the calculations that are established. EE expertise on how to approach Excel security would be appreciated.