Excel Worksheet Tips: Hiding Buttons When Printing

Excel Worksheet Tips: Hiding Buttons When Printing

You may have a sheet that contains buttons, which when pressed, perform an action. When printing an active sheet, these buttons will be displayed on the printout. This may not be desired, as it doesn’t look professional. To remove these from printing:

1. Ensure you are in design mode by opening the developer tab and selecting design mode.
2. Right click on the button. Select ‘properties’ from the drop down list.
3. In the properties dialog box, you will find a property labelled ‘PrintObject’ – select False.

Now, when you print the sheet, the button will not be displayed.

If you like this post, come check out the rest of my excel tips!

Come check out the directory for the rest of my excel tips!

Submeg

IT