| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to show date printed, updated only when worksheet printed? | Excel Discussion (Misc queries) | |||
| Option Buttons/Radio Buttons | New Users to Excel | |||
| Form buttons vs. ActiveX Buttons | Excel Discussion (Misc queries) | |||
| have toggle buttons but everytime print preview buttons move | Excel Discussion (Misc queries) | |||
| Control Buttons vs. Command Buttons | Excel Programming | |||
Linear Mode
