Do not print a button when print

M

Man Utd

I have a button on a worksheet and sometime ago I have set/written code to
hide the button when printing.
I forget I set the property or by macro.
 
N

Neil

In 'Design Mode', right click your button, and Select 'Properties' from the
context menu, in the properties dialog you will find a property called
'PrintObject', set this to either Yes or No depending on your preference.

HTH

Neil
www.nwarwick.co.uk
 
M

Man Utd

Sorry, how do I go into Design Mode ?

Neil said:
In 'Design Mode', right click your button, and Select 'Properties' from the
context menu, in the properties dialog you will find a property called
'PrintObject', set this to either Yes or No depending on your preference.

HTH

Neil
www.nwarwick.co.uk
Click to expand...
 
P

Peo Sjoblom

View>toolbars>control toolbox, click on the triangle/ruler/pencil

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Publisher adding blank page when printing my booklet... 2
Office Word JPEG in a document showing but not printing out 0
Gantt task bars not printing 2
Printing Outline view - formatting lost 0
Table of content - format does not get saved 2
Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
Print order of TriFold - Publisher 365 0
Printing from Word my Inserted Pictures colors are dull and lack color 0

Top