Forum Discussion
AndyMaynard
Sep 13, 2024Copper Contributor
Multiple form printing
I print a set of forms monthly for hand completion by about 40 building sites. Each form is identical but for Site names and codes and foreman names, which can require editing each month; and the wee...
BeckettPhoenix
Mar 20, 2025Bronze Contributor
1. Use the print area: Select the cell area to be printed.
Click “Page Layout” > “Print Area” > “Set Print Area”.
Repeat the above steps to set the print area for other forms.
2. Use Print Header: Click “Page Layout” > “Print Header”.
Set the row and column headers in the Print Headers dialog box.
3. Using VBA Script: Press Alt + F11 to open the VBA editor.
Insert a new module and enter the following code:
vba
Sub PrintMultipleSheets()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.PrintOut
Next ws
End Sub
Run the script to print all the worksheets.
4. Use Print Preview: Click File > Print.
Check the printing effect of each form in the print preview.