Buttons not to be printed
 

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

Buttons not to be printed
 

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


"Jean-Paul De WInter" wrote:

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

Buttons not to be printed
 

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.

--
Regards,
Tom Ogilvy

"Jean-Paul De WInter" wrote in message
...
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

Buttons not to be printed
 

je meent het.... zooooo simpel??
Bedankt
JP
"keepITcool" schreef in bericht
...
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


"Jean-Paul De WInter" wrote:

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