Formatting Issues

How to Apply Picture Formatting to Multiple Pages in Publisher

Maira Mehtab Sep 22, 2026 868 views

Question details

The user wants to apply identical picture dimensions and positions across multiple pages in a document, but lacks a built-in batch-formatting command to do so.

Product: Microsoft Publisher
Device & OS: not provided
Scenario: Standardizing image sizes and placements across a large document with multiple pages.
Observed behavior: Copying and pasting changes image placement or causes overlapping objects, and there is no native tool to batch-format the pictures.

Before you start

Before running any VBA macros, ensure you save a backup copy of your Publisher file in case the script causes unexpected layout changes.

Solution 1Recommended

Use a VBA Macro to Batch Format Pictures

Since Publisher lacks a native batch-formatting tool, a VBA macro is the most efficient way to automatically resize and position images across all pages.

A VBA macro can automatically loop through every page in your document, target all picture objects, and set them to your desired width and height.

Keep in mind that VBA uses points for measurement instead of inches or centimeters. There are 72 points in an inch, so you will need to calculate your target dimensions accordingly.

Open the VBA Editor

Press Alt + F11 in Microsoft Publisher to launch the Visual Basic for Applications (VBA) editor window.

Insert a New Module

Click 'Insert' from the top menu bar, then select 'Module' to create a blank script window for your macro.

Write the Macro Code

Write a script that iterates through 'ActiveDocument.Pages' and targets 'Shapes' classified as pictures. If you need independent width and height adjustments, ensure you set 'LockAspectRatio' to 'msoFalse' in your code.

Set Dimensions in Points

Assign your target width and height using points. Multiply your desired measurement in inches by 72 (for example, 2 inches equals 144 points).

Run the Macro

Press F5 on your keyboard or click the 'Run' icon in the toolbar to apply the picture formatting across all pages.

Aspect Ratio: If your images become distorted after running the macro, you may need to adjust the LockAspectRatio property in your VBA script to maintain their original proportions.

Free Microsoft Office alternative

Try WPS Office for Seamless Document Formatting

If you are tired of writing complex VBA macros just to format multiple pictures, consider using WPS Office for your document layout needs. It is a free, lightweight, and highly compatible productivity suite that offers familiar UI and seamless migration from Microsoft Office.

1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
2. Open Your Document: Launch WPS Writer or Presentation and open your layout document.
3. Utilize Advanced Formatting: Select multiple images by holding the Ctrl key, then use the Picture Tools menu to apply uniform sizes and alignments instantly.

Easily format and align multiple images within your documentsFully compatible with Microsoft Word, Excel, and PowerPoint formatsLightweight application that runs smoothly on most devicesFamiliar user interface for quick adoption without a learning curve

Frequently Asked Questions

Can I batch format pictures in Publisher without using VBA?

Unfortunately, Microsoft Publisher does not include a native batch-formatting feature for pictures. You must either use a VBA macro or manually resize and position each image one by one.

How do I calculate points for picture dimensions in a VBA macro?

In VBA, measurements are calculated in points, where 72 points exactly equal 1 inch. To find your target size, simply multiply your desired inches by 72. For instance, 3 inches would be 216 points.

Why do my pictures overlap when I copy and paste them across pages?

When copying and pasting objects in Publisher, the software often offsets the pasted items slightly from the original coordinates to make them visible over the original item, which can lead to cascading overlaps if repeated across many pages.

Document & File Issues