Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

vba macro

ResolvedVersion 2010

Jonathan has attended:
Access Introduction course
Excel VBA Intro Intermediate course
Access Intermediate course
Access Intermediate course
Excel Advanced course

VBA Macro

how do i sent print preview command in excel VBA

RE: VBA Macro

Hello Jonathan,

You can set the print preview in the following way:

Sheets("Sheet1").Printout preview:=true



I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Sun 5 May 2013: Automatically marked as resolved.

 

Training courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Switch between workbooks ni EXCEL.

use Alt-TAB to switch between workbooks.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.2 secs.