98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
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
Resolved · Low Priority · Version 2003
Fri 20 Jun 2008, 15:57Delegate 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:18Trainer 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:=1I suggest that you look up the printout method in the object browser to get a full understanding of its parameters
Regards
Stephen
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Printing spreadsheets without opening them firstHere's a fast way of printing a spreadsheet from Windows Explorer/My Computer. |
