Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Setting up a print option in VB

Setting up a print option in VB

ResolvedVersion 2003

Fri 20 Jun 2008, 15:57 Delegate Karen said...

Karen has attended:
Excel VBA Intro Intermediate course

Setting up a print option in VB

How can you set a print option in VB?

Thanks

Mon 23 Jun 2008, 14:18 Trainer Stephen said...

RE: Setting up a print option in VB

Hi Karen

Thank you for your question

You can do this using the printout method of the active window object. You first need to write the code to select the sheet that you want printing and then use the following line of code

ActiveWindow.SelectedSheets.PrintOut Copies:=1

I suggest that you look up the printout method in the object browser to get a full understanding of its parameters

Regards

Stephen

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Applying and removing border from cell in Excel 2010

Did you know the shortcut key for applying and removing the outline border for a cell?

CTRL+SHIFT+& Applies the outline border to the selected cells.
CTRL+SHIFT_ Removes the outline border from the selected cells.

View all Excel hints and tips

Setting up a print option in VB

Setting up a print option in VB

RE: Setting up a print option in VB

Excel articles

Excel tip:

Applying and removing border from cell in Excel 2010