Excel has a few security features that come in handy when you are using, and especially sharing, data in a workbook. You can choose what personal information Excel stores with your files and adjust security settings as well. Use the following articles to understand and utilize security in Excel.
Tips, Tricks, and Answers
The following articles are available for the 'Security' topic. Click the article''s title (shown in bold) to see the associated article.
Automatically Enabling Macros for Specific Workbooks
On your system you may have workbooks that contain macros you know are safe to use. Microsoft provides two things you can do with such workbooks that will cause those workbooks to load without impediment. This tip looks at both trusted locations and provides a link to additional information about digital signatures.
Do your macros seem to be disabled on your new machine? It could be because of the security settings in Excel. Here's where they are located and how to change them.
Limiting Where a Workbook is Used
Want to limit who can use your workbook and on what system? Locking down a workbook can be trickier than you might imagine.
Removing Personal Information
As you create and work on your workbooks, Excel can include sensitive personal information with the data. If you want to get rid of this information, you can do so by using the tools described in this tip.