The Add-Ins tab disappears if it is active when you try to print a workbook from the print preview in Excel 2007

Article translations Article translations
Article ID: 933787 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

If you try to print a workbook from the print preview when the Add-Ins tab is active in Microsoft Office Excel 2007, the Add-Ins tab disappears.

Note If you exit Excel 2007 and then restart Excel 2007, the Add-Ins tab reappears.

WORKAROUND

To work around this problem, click a tab other than the Add-Ins tab to make the other tab active before you print the workbook from the print preview.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

Steps to reproduce the problem

  1. Start Excel 2007.
  2. Create a new workbook.
  3. On the Developer tab, click Visual Basic in the Code group to start the Microsoft Visual Basic Editor (VBE).
  4. Add the following code to the ThisWorkbook module.
    Private Sub Workbook_Open()
     
        Dim sheetbar As Office.CommandBar 
        Dim menubar As Office.CommandBarControl 
        Dim dlitem As Office.CommandBarControl 
        Dim cmdbutton As Office.CommandBarButton 
        Dim cnt As Integer
     
        On Error Resume Next 
         
        Set sheetbar = Application.CommandBars("worksheet menu bar") 
        Set menubar = sheetbar.Controls("PI") 
        If menubar Is Nothing Then 
            Set menubar = sheetbar.Controls.Add(msoControlPopup, temporary:=True, before:=10) 
            menubar.Caption = "&PI" 
        End If
     
    End Sub
    
    
    
  5. On the File menu, click Save.
  6. In the Save As dialog box, type myadd-in in the File name box, click Excel Add-In or Excel 97-2003 Add-In in the Save as type list, and then click Save.
  7. Exit Excel 2007.
  8. Restart Excel 2007.
  9. Create a new workbook.
  10. Click the Microsoft Office Button, and then click Excel Options.
  11. Click Add-Ins.

    Notice that myadd-in is listed in the Inactive Application Add-ins section in the Add-ins list.
  12. Click Excel Add-ins in the Manage list, and then click Go.
  13. In the Add-Ins dialog box, click to select the myadd-in check box, and then click OK.

    Notice that the Add-Ins tab appears in Excel 2007.
  14. In the Excel workbook, add any data.
  15. Click the Add-Ins tab to make the tab active.
  16. Click the Microsoft Office Button, point to Print, and then click Print Preview.
  17. On the Print Preview tab, click Print in the Print group.

    Notice that when the Print dialog box appears, the Add-Ins tab in the workbook disappears.

Properties

Article ID: 933787 - Last Review: March 12, 2007 - Revision: 1.0
APPLIES TO
  • Microsoft Office Excel 2007
Keywords: 
kbexpertisebeginner kbtshoot kbprb KB933787

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com