Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
VB Command Button
Hiya guys....
I have created a VB Button into my word document which has a macro attached to it. But when I print the page I dont want to show the button, How can I change it so the button only sppears in the page and not on the printed documents? Alistaire |
#2
|
|||
|
|||
VB Command Button
LW_Greeney wrote:
Hiya guys.... I have created a VB Button into my word document which has a macro attached to it. But when I print the page I dont want to show the button, How can I change it so the button only sppears in the page and not on the printed documents? Alistaire See http://word.mvps.org/FAQs/TblsFldsFm...rintButton.htm. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org |
#3
|
|||
|
|||
VB Command Button
hi jay,
have have done what it says, but i have more than one button within all the document, have have 6 pages with buttons on each? does this work for all buttons? "Jay Freedman" wrote: LW_Greeney wrote: Hiya guys.... I have created a VB Button into my word document which has a macro attached to it. But when I print the page I dont want to show the button, How can I change it so the button only sppears in the page and not on the printed documents? Alistaire See http://word.mvps.org/FAQs/TblsFldsFm...rintButton.htm. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org |
#4
|
|||
|
|||
VB Command Button
Do all the buttons do the same thing -- print the entire document? Or do
they have separate functions, like printing the current page? In fact, do they print at all, or do their macros do something else? -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org LW_Greeney wrote: hi jay, have have done what it says, but i have more than one button within all the document, have have 6 pages with buttons on each? does this work for all buttons? "Jay Freedman" wrote: LW_Greeney wrote: Hiya guys.... I have created a VB Button into my word document which has a macro attached to it. But when I print the page I dont want to show the button, How can I change it so the button only sppears in the page and not on the printed documents? Alistaire See http://word.mvps.org/FAQs/TblsFldsFm...rintButton.htm. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org |
#5
|
|||
|
|||
VB Command Button
There is only 1 button that prints, then the rest are just buttons to move
about the document! All buttons are macros going to a different bookmark on the document. I know in excel there is an option called printobject which you can change to failse but i cannot find that in word. "Jay Freedman" wrote: Do all the buttons do the same thing -- print the entire document? Or do they have separate functions, like printing the current page? In fact, do they print at all, or do their macros do something else? -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org LW_Greeney wrote: hi jay, have have done what it says, but i have more than one button within all the document, have have 6 pages with buttons on each? does this work for all buttons? "Jay Freedman" wrote: LW_Greeney wrote: Hiya guys.... I have created a VB Button into my word document which has a macro attached to it. But when I print the page I dont want to show the button, How can I change it so the button only sppears in the page and not on the printed documents? Alistaire See http://word.mvps.org/FAQs/TblsFldsFm...rintButton.htm. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org |
#6
|
|||
|
|||
VB Command Button
There is an option labeled "Drawing objects" on the Print tab of the Tools
Options dialog that controls whether Word prints the drawing objects in the document. For this purpose, drawing objects include text boxes as well as pictures, AutoShapes, and other graphics. If the text boxes containing the command buttons are the only drawing objects in the document, you could uncheck that option and print, and none of the text box/command button objects would be printed. To do this automatically, open the macro attached to the button that prints, and put this code between the Sub line and the End Sub line: ' declare a variable Dim bOptPrintDrawings As Boolean ' save the existing option value bOptPrintDrawings = Options.PrintDrawingObjects Options.PrintDrawingObjects = False ' print the document ActiveDocument.PrintOut Background:=False ' restore the option to original value Options.PrintDrawingObjects = bOptPrintDrawings If your document has other drawing objects, then we'll have to do something more complicated. If that's the case, are these six the only text boxes in the document? -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org LW_Greeney wrote: There is only 1 button that prints, then the rest are just buttons to move about the document! All buttons are macros going to a different bookmark on the document. I know in excel there is an option called printobject which you can change to failse but i cannot find that in word. "Jay Freedman" wrote: Do all the buttons do the same thing -- print the entire document? Or do they have separate functions, like printing the current page? In fact, do they print at all, or do their macros do something else? -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org LW_Greeney wrote: hi jay, have have done what it says, but i have more than one button within all the document, have have 6 pages with buttons on each? does this work for all buttons? "Jay Freedman" wrote: LW_Greeney wrote: Hiya guys.... I have created a VB Button into my word document which has a macro attached to it. But when I print the page I dont want to show the button, How can I change it so the button only sppears in the page and not on the printed documents? Alistaire See http://word.mvps.org/FAQs/TblsFldsFm...rintButton.htm. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org |