Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Youngstown, Ohio, USA
    Thanked 0 Times in 0 Posts

    Selfcert vs Office 2007 (Office 2000)

    I used selfcert to create a certificate and enable me to sign my vba macros, but this doesn't appear to help when my Office 2000 files are opened up in Office 2007. The option to 'always trust' is greyed out and the only option on opening is to disable macros. Is a newer selfcert available? Perhaps the Office 2007 macro security settings are set too high?

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Thanked 1 Time in 1 Post

    Re: Selfcert vs Office 2007 (Office 2000)

    For details of how to create a new self certificate in Office 2007 see Digitally sign a macro project

    Another option is if your files are in the same folder you can tell Excel to always trust files in that folder.

    Click on the Office logo then click on "Excel Options"
    In the left hand pane select "Trust Center" then click "Trust Center Settings"
    In the left pane click "Trusted locations" then click "Add New Location" to add the folder that contains your Excel files.

    You can use the same method for other Office applications.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts