FIX: Visual Basic 6 .0 UserControl in Excel Does Not Print or Display in Print Preview

View products that this article applies to.

This article was previously published under Q249607

SYMPTOMS

When you attempt to Print or Print Preview an Microsoft Excel 97 or Microsoft Excel 2000 workbook containing a UserControl that was created in Visual Basic 6.0, the UserControl does not print or display in the Print Preview window.

The problem does not occur when using the UserControl in other Microsoft Office applications. The problem does not occur with a UserControl created in Visual Basic version 5.0.

Back to the top

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article. This bug was corrected in the latest service pack for Visual Studio 6.0.

For additional information about Visual Studio service packs, click the following article numbers to view the articles in the Microsoft Knowledge Base:

194022 (http://support.microsoft.com/kb/194022/EN-US/ ) INFO: Visual Studio 6.0 Service Packs, What, Where, Why

194295 (http://support.microsoft.com/kb/194295/EN-US/ ) HOWTO: Tell That a Visual Studio Service Pack Is Installed

To download the latest Visual Studio service pack, visit the following Microsoft Web site:

http://msdn2.microsoft.com/en-us/vstudio/Aa718353.aspx (http://msdn2.microsoft.com/en-us/vstudio/Aa718353.aspx)

Back to the top

MORE INFORMATION

Steps to Reproduce Behavior

In Visual Basic, create a new ActiveX Control project. Project1 is created by default. UserControl1 is added by default.
Change Project1's Name property to prjTestExcel. Change UserControl1's Name property to ctlTestExcel.
Add a Label control to UserControl1. Label1 is created by default. You do not need to modify Label1's default properties any further.
Save the UserControl as ctlTestExcel.ctl. Save the Project as prjTestExcel.vbp.
Compile the Project to prjTestExcel.ocx. Exit from Visual Basic.
Start Microsoft Excel version 97 or 2000. Book1 is opened by default.
From the View menu in Excel, click to select Toolbars. From the list of available Toolbars, click to select Control Toolbox.
At the bottom of the Control Toolbox, click the More Controls icon. From the list of More Controls, select prjTestExcel.ctlTestExcel. Drag in Book1 to draw an instance of the UserControl in the workbook.

NOTE: If the UserControl is not in the list of More Controls, do the following:
1. Select Register Custom Control from the list of More Controls.
2. Navigate to the OCX file in the Register Customer Control dialog box.
Once the UserControl has been placed and sized on the form, select to either Print or Print Preview the workbook. Note that the UserControl does not appear on a printout and the UserControl does not appear in the Print Preview window.