Do not print a button when print

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.

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.
>
>
>

Sorry, how do I go into Design Mode ?

"Neil" <Neil@discussions.microsoft.com> wrote in message
news:E5348398-A546-4F4A-B87B-BF6FD12FB4BA@microsoft.com...
> 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.
> >
> >
> >

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

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"Man Utd" <alanpltseNOSPAM@yahoo.com.au> wrote in message
news:OCodpC3MGHA.3064@TK2MSFTNGP10.phx.gbl...
> Sorry, how do I go into Design Mode ?
>
> "Neil" <Neil@discussions.microsoft.com> wrote in message
> news:E5348398-A546-4F4A-B87B-BF6FD12FB4BA@microsoft.com...
>> 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.
>> >
>> >
>> >
>
>