View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom
 
Posts: n/a
Default Do not print a button when print

Viewtoolbarscontrol toolbox, click on the triangle/ruler/pencil

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"Man Utd" wrote in message
...
Sorry, how do I go into Design Mode ?

"Neil" wrote in message
...
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

"Man Utd" wrote:

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.