Buttons not to be printed

  • Thread starter Thread starter Jean-Paul De WInter
  • Start date Start date
J

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
 
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 >
 
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.
 
je meent het.... zooooo simpel??
Bedankt
JP
keepITcool said:
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 >
 
Back
Top