|
|
|
|
|
|
Word
|
Open Document In Print Preview
|
|
Ease of Use
|
Easy
|
Version tested with
|
2000, 2002
|
Submitted by:
|
MOS MASTER
|
Description:
|
The document is opened in Print Preview
|
Discussion:
|
A easy way to open documents directly in to Print Preview so you can take a last peak before you print it. (Like reports you need to print)
|
Code:
|
instructions for use
|
Option Explicit
Private Sub Document_Open()
ActiveDocument.Print Preview
ActiveWindow.ActivePane.View.Zoom.Percentage = 100
End Sub
|
How to use:
|
- Open your Word document.
- Press Alt + F11 to open the VBE window.
- Double click "ThisDocument" on the project explorer. (press CTRL+R to view)
- Paste the code there in the window at right. (F7)
- Close VBE (Alt + Q or press the X in the top right hand corner).
- Save the file.
|
Test the code:
|
- Open the document by double clicking on it
- Choose yes to enable Macro's
- The document is opened in Print Preview
|
Sample File:
|
Open in printpreview.zip 12.67KB
|
Approved by mdmackillop
|
This entry has been viewed 83 times.
|
|