Print a control on a worksheet
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.
-
If one or more controls is an ActiveX control:
-
Make sure that the Developer tab is available.
Display the Developer tab
-
Click the Microsoft Office Button , and then click Excel Options.
-
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.
-
-
Make sure that you are in design mode. On the Developer tab, in the Controls group, turn on Design Mode .
-
-
Select the control or controls that you want to print.
For more information, see Select or deselect controls on a worksheet.
-
Right-click the selection, click Format Control, and then click the Properties tab.
-
Select Print object.