Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Print Preview Screen Display for The Entire Workbook in Excel
This is a great macro to assign to a button to enable users to more quickly and easily view their Excel files in the print preview mode.
Where to install the macro: Module
Macro to Display The Print Preview Screen for The Entire Workbook in Excel
Sub Print_Preview_Entire_Workbook()
'Show the print preview window for the entire active Excel workbook or file
Worksheets.PrintPreview
End Sub
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Similar Content on TeachExcel
Print Preview Screen Display for The Current or Selected Worksheets in Excel
Macro: This free Excel macro allows you to display the print preview screen or window for the cur...
Macro: This free Excel macro allows you to display the print preview screen or window for the cur...
Print Entire Workbook in Excel
Macro: This free excel macro allows you to print the entire workbook in Excel. You can easil...
Macro: This free excel macro allows you to print the entire workbook in Excel. You can easil...
Vlookup Function That Searches The Entire Workbook in Excel - UDF
Macro: With this VLOOKUPWORKBOOK function, you will have to power to more quickly and easily ana...
Macro: With this VLOOKUPWORKBOOK function, you will have to power to more quickly and easily ana...
Hide Comments in Excel Partially - Comment Indicator Shows and Will Display on Hover
Macro: Hide comments in Excel with this macro. Comment indicators will still appear in the ce...
Macro: Hide comments in Excel with this macro. Comment indicators will still appear in the ce...
List All Named Ranges in Excel - Displays the Name and Value for Every Named Range Within the Active Workbook in Excel
Macro: List all of the named ranges in a workbook in Excel and the corresponding values store...
Macro: List all of the named ranges in a workbook in Excel and the corresponding values store...
Make Excel Easier to Read
Tutorial: How to make Excel easier to read by increasing the font size or zooming in. Sections: Incr...
Tutorial: How to make Excel easier to read by increasing the font size or zooming in. Sections: Incr...
How to Install the Macro
- Select and copy the text from within the grey box above.
- Open the Microsoft Excel file in which you would like the Macro to function.
- Press "Alt + F11" - This will open the Visual Basic Editor - Works for all Excel Versions.
Or For other ways to get there, Click Here.
- On the new window that opens up, go to the left side where the vertical pane is located. Locate your Excel file; it will be called VBAProject (YOUR FILE'S NAME HERE) and click this.
- If the Macro goes in a Module, Click Here, otherwise continue to Step 8.
- If the Macro goes in the Workbook or ThisWorkbook, Click Here, otherwise continue to Step 8.
- If the Macro goes in the Worksheet Code, Click Here, otherwise continue to Step 8.
- Close the Microsoft Visual Basic Editor window and save the Excel file. When you close the Visual Basic Editor window, the regular Excel window will not close.
- You are now ready to run the macro.