MS-Excel / General Formatting

Digital Signature to a Macro Tips

  • If you have macro security enabled, Excel displays a warning just below the Ribbon when you open a workbook containing a signed macro. You can click the Options button located next to the warning to open the Microsoft Office Security Options dialog box, where you can indicate that you trust the publisher. Excel then saves the name of the publisher in the Trusted Publishers section of the Trust Center.
  • If you click the Macro Security button on the Developer tab, the Trust Center dialog box appears. Click Trusted Publisher to display a list of your trusted publishers.
    If you no longer want to trust macros from a publisher listed on the Trusted Publishers page, click the name of the publisher and then click Remove. The next time you open a workbook with a macro from a removed publisher, Excel again warns you about its macros.
  • Unless you have your macro settings set to enable all macros, Excel checks all documents you open for macros. If you have a file that you do not want Excel to check, you can store it in a trusted location. In the Trust Center dialog box, click Trusted Locations to define a trusted location.
  • You can find out more about obtaining a digital commercial certification from VeriSign at www.verisign.com.
[Previous] [Contents]