Print a control on a worksheet

You may want to print a control because it contains data or images that you want to include on a printed document.

1. If one or more controls is an ActiveX control:

   1. Make sure that the Developer tab is available.

      Display the Developer tab

      1. Click the Microsoft Office Button , and then click Excel Options.

      2. In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

         Note: The Ribbon is a component of the Microsoft Office Fluent user interface.

   2. Make sure that you are in design mode. On the Developer tab, in the Controls group, turn on Design Mode .

2. Select the control or controls that you want to print.

   For more information, see Select or deselect controls on a worksheet.

3. Right-click the selection, click Format Control, and then click the Properties tab.

4. Select Print object.