locked
Trusted Publisher certificate RRS feed

  • Question

  • Hello,

    What is the best (quick/easy/inexpensive) way to get a Trusted Publisher certificate?

    Thank you!

    Thursday, June 1, 2017 10:41 PM

Answers

  • Hi julia555,

    I try to search further and I find that this is related with Group policies.

    you need to check group polices.

    please check table below. it is looks like your ribbon is disabled because of these policies.

    Policy

    Description

    New for Office 2010 or Existing Policy

    Affects Ribbon or Quick Access Toolbar

    Turn off user customizations via UI

    This policy setting prevents users from customizing both the Quick Access Toolbar and Ribbon through the user interface (UI).

    This policy setting does not affect existing customizations that load when the application starts, or load when an associated document or template is opened.

    If you enable this policy setting, the following UI entry points are turned off: the Quick Access Toolbar and Ribbon tabs in the application's Office Center dialog box, and the Quick Access Toolbar and Ribbon customization options on the right-click menu on the Ribbon.

    If you disable or do not configure this policy setting, users can customize the Quick Access Toolbar and Ribbon through both the application’s Office Center dialog box, and the right-click menu on the Ribbon.

    Existing

    Both

    Turn off all user customizations

    This policy setting prevents users from making any Quick Access Toolbar and the Ribbon customizations. This includes customizations made through user interface (UI) entry points, or loaded from documents or templates. Existing customization files do not load when the application starts.

    If you enable this policy setting, users cannot customize the Quick Access Toolbar and Ribbon through either the Quick Access Toolbar and Ribbon tabs in the application's Office Center dialog box, or the right-click menu on the Ribbon. In addition, Quick Access Toolbar and Ribbon customizations originating from documents or templates are not loaded when these documents are opened. In addition, existing customization files (*.officeUI) are not loaded when the application starts. Users will be unable to Import a Customization file (*.exportedUI).

    If you disable or do not configure this policy setting, users can make Quick Access Toolbar and Ribbon customizations through the UI and load them from documents and templates, or customization files.

    Existing

    Both

    Disable UI extending from documents and templates

    This policy setting controls whether Office 2010 applications load any custom user interface (UI) code included with a document or template. The Office 2010 release enables you to extend the UI with customization code that is included in a document or template.

    If you enable this policy setting, Office 2010 applications cannot load any UI customization code included with documents and templates.

    If you disable or do not configure this policy setting, Office 2010 applications load any UI customization code included with a document or template when you open it.

    Existing

    Not applicable

    Allow roaming of all user customizations

    This policy setting allows roaming of both the Quick Access Toolbar and Ribbon customizations. 

    If you enable this policy setting, users' Quick Access Toolbar and Ribbon customizations will be available to them on any computer on their network when they log on.

    If you disable or do not configure this policy setting, users' Quick Access Toolbar and Ribbon customizations will only be available to them on the computer on which they made the customizations.

    New

    Both

    Reference:

    Deploying a Customized Ribbon and Quick Access Toolbar in Office

    To customize the Administrative Policies for the User Interface in Windows Server 2008 R2

    1. Open the Group Policy Management Console. Right-click the Group Policy object that you want to edit and then click Edit.

    2. In the console tree, under User Configuration, expand Administrative Templates.

    3. Click Classic Administrative Templates, Microsoft Office 2010 system, Global Options, and then click Customize.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by julia555 Sunday, June 11, 2017 11:50 AM
    Friday, June 9, 2017 1:05 AM

All replies

  • Hi julia555,

    if you are working with VBA then you can try to Create a self-signing certificate.

    1. In the Your certificate's name box, type a descriptive name for the certificate.     

    2. Click OK.

    3. When the SelfCert Success message appears, click OK.

    4. Click Start, point to All Programs, click Microsoft Office, click Microsoft Office Tools, and then click Digital Certificate for VBA Projects.
      The Create Digital Certificate dialog box appears.
            

    Reference:

    Create a self-signing certificate

    How to specify trusted sources for Digital Certificates in Excel, in PowerPoint, in and Word

    Add, remove, or view a trusted publisher

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Monday, June 5, 2017 5:57 AM
  • Deepak, 

    Many thanks for your reply!

    I have just one more question.

    A number of companies have been using our application (.xlsb workbook) in Excel 2007/10/13/16 without any problems for 10+years. Only two users recently reported the custom ribbon tabs missing (they both just upgraded to Office Professional Plus 2016 by their ITs).

    So, if I sign my VBA project with this certificate (that is needed for two users) , would I have to ask ALL our clients to add this Certificate to the Certificates Store on their computers?
        
    Thank you!
    Julia


    Monday, June 5, 2017 4:53 PM
  • Hi julia555,

    I think that you need to check what's wrong with the ribbon.

    It is possible that issue is not related with certificate and the cause for this issue is something else.

    because it was working without certificate till now.

    did you try to create certificate? is that solved your issue?

    here I want to confirm with you that which older version they are using?

    I suggest you to try to reproduce the issue with other 2016 versions, so that we can see that the issue is related with specific version or can reproduce on any version.

    if possible for you then you can try to open same file on different machine to check whether it shows the ribbon or not.

    you can also try to provide steps to reproduce the issue so that we can also try to make a test on our side.

    if creating the certificate solves your issue then you need to create it whenever your user meet with this issue and you can create it in advance to avoid the issue.

    Regards

    Deepak 


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, June 6, 2017 7:47 AM
  • Deepak, 

    When users who got upgraded to Office Professional Plus 2016 and reported the custom ribbon tabs missing, turned ON "Show Add-in User Interface Errors" option they got message "The custom UI associated with this document has been disabled by policy".   What is interesting - all right mouse click functions, all macros, all user forms worked fine; only  custom ribbon tabs missing.

    The same application (.xlsb workbook) with the same ribbon work  fine to other users (different companies) who have other 2016 MS Office products - Office Home & Student, Office Home & Business, Office Professional.

    So, it looks like Office Professional Plus 2016 requirements(policies?) are different? These companies have been using our software (with custom ribbon tabs) for many years without any problems.

    Thank you,
    Julia


    Wednesday, June 7, 2017 4:16 PM
  • Hi julia555,

    I try to search further and I find that this is related with Group policies.

    you need to check group polices.

    please check table below. it is looks like your ribbon is disabled because of these policies.

    Policy

    Description

    New for Office 2010 or Existing Policy

    Affects Ribbon or Quick Access Toolbar

    Turn off user customizations via UI

    This policy setting prevents users from customizing both the Quick Access Toolbar and Ribbon through the user interface (UI).

    This policy setting does not affect existing customizations that load when the application starts, or load when an associated document or template is opened.

    If you enable this policy setting, the following UI entry points are turned off: the Quick Access Toolbar and Ribbon tabs in the application's Office Center dialog box, and the Quick Access Toolbar and Ribbon customization options on the right-click menu on the Ribbon.

    If you disable or do not configure this policy setting, users can customize the Quick Access Toolbar and Ribbon through both the application’s Office Center dialog box, and the right-click menu on the Ribbon.

    Existing

    Both

    Turn off all user customizations

    This policy setting prevents users from making any Quick Access Toolbar and the Ribbon customizations. This includes customizations made through user interface (UI) entry points, or loaded from documents or templates. Existing customization files do not load when the application starts.

    If you enable this policy setting, users cannot customize the Quick Access Toolbar and Ribbon through either the Quick Access Toolbar and Ribbon tabs in the application's Office Center dialog box, or the right-click menu on the Ribbon. In addition, Quick Access Toolbar and Ribbon customizations originating from documents or templates are not loaded when these documents are opened. In addition, existing customization files (*.officeUI) are not loaded when the application starts. Users will be unable to Import a Customization file (*.exportedUI).

    If you disable or do not configure this policy setting, users can make Quick Access Toolbar and Ribbon customizations through the UI and load them from documents and templates, or customization files.

    Existing

    Both

    Disable UI extending from documents and templates

    This policy setting controls whether Office 2010 applications load any custom user interface (UI) code included with a document or template. The Office 2010 release enables you to extend the UI with customization code that is included in a document or template.

    If you enable this policy setting, Office 2010 applications cannot load any UI customization code included with documents and templates.

    If you disable or do not configure this policy setting, Office 2010 applications load any UI customization code included with a document or template when you open it.

    Existing

    Not applicable

    Allow roaming of all user customizations

    This policy setting allows roaming of both the Quick Access Toolbar and Ribbon customizations. 

    If you enable this policy setting, users' Quick Access Toolbar and Ribbon customizations will be available to them on any computer on their network when they log on.

    If you disable or do not configure this policy setting, users' Quick Access Toolbar and Ribbon customizations will only be available to them on the computer on which they made the customizations.

    New

    Both

    Reference:

    Deploying a Customized Ribbon and Quick Access Toolbar in Office

    To customize the Administrative Policies for the User Interface in Windows Server 2008 R2

    1. Open the Group Policy Management Console. Right-click the Group Policy object that you want to edit and then click Edit.

    2. In the console tree, under User Configuration, expand Administrative Templates.

    3. Click Classic Administrative Templates, Microsoft Office 2010 system, Global Options, and then click Customize.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by julia555 Sunday, June 11, 2017 11:50 AM
    Friday, June 9, 2017 1:05 AM
  • Deepak,

    Thank you!!!

    I think this is exactly what I was looking for!!

    Regards,

    Julia


    Friday, June 9, 2017 4:26 AM
  • Deepak,

    Just letting you know - the setting "Disable the UI Extending from Documents and Templates" was changed by client's IT from "enabled" to "not configured" and my custom ribbon tabs appeared again.

    Many, many thanks!!!

    Julia
    Sunday, June 11, 2017 11:49 AM