How to Take Print Without Objects

 
How to Take Print Without Objects?

Follow the steps below if you do not want to print objects in a worksheet.

1 Suppose you have some data and a button in your worksheet and you wantonly the data to be printed without the button.
2 Right click on the button which you do not want to print and select ‘Format Control’.
3 Select Properties in ‘ Format Control’ . Uncheck ‘ Print Object’.
4 Click OK. When you select the ‘print preview’, Now you can see the print out without the object.

Reason: