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

Posted by:submeg

Musician, Writer and Inspirer. I discuss the projects I am working on, the services I provide and my general thoughts.

Tell me what you think!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s