Forum Discussion
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...
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.