Buttons not to be printed

[Jean-Paul De WInter]

Hi,
I have a worksheet with some pushbuttons on it...
When I print the sheet, the buttons are printed too...
How to prevent this?
Thanks
JP

 

[keepITcool]

let's try something really crazy..

right click the button
choose "Format control" ("Besturings element opmaken")
look at the tab properties. ("Kenmerken")


do you see a checkmark for "Print Object" ("Object afdrukken") ?

Ah mai!!! <g>

btw... a more logical choice would be to post this
in another newsgroup... Ms.Public.Nl.Office.Excel
see ya there



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Tom Ogilvy]

right click on the button and select format control. go to properties and
uncheck Print Object

If it is an ActiveX CommandButton, go into design mode first.

 

[Jean-Paul De WInter]

je meent het.... zooooo simpel??
Bedankt
JP

let's try something really crazy..

right click the button
choose "Format control" ("Besturings element opmaken")
look at the tab properties. ("Kenmerken")


do you see a checkmark for "Print Object" ("Object afdrukken") ?

Ah mai!!! <g>

btw... a more logical choice would be to post this
in another newsgroup... Ms.Public.Nl.Office.Excel
see ya there



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >