Summary

All things considered, from a security standpoint Excel 2007 has become much less friendly to VBA code than previous versions of Excel. The good news is that all of the settings that control how Excel responds to VBA code have been gathered in one location, the new Trust Center. When you are having problems getting your VBA applications to run, you will need an excellent understanding of the settings in the Trust Center to distinguish between bugs in your code and problems caused by Excel security features.

If you or your company needs to send workbooks to someone who may try to extract personal information from them, the RemoveDocumentInformation method and the DocumentInspector object can help you ensure that your workbooks don't contain any such information.

0 0

Post a comment