Geek Documentation Logo


Version 1.1


If you have already purchased this Software, let me take a moment to thank you for being a loyal customer
You are entitled to free lifetime updates for ALL future builds

This documentation is to help you understand the Software and to give you a more meaningful insight into what it can do. Please go through the documentation and read it carefully · Basic Excel skills will be required


You will need the following Excel Version & Prerequisite to use this Software

  1. Excel 2010, 2013 & 2016 (32bit or 64bit)
  2. Basic skills
  3. Access to the VBOM (a setting in Excel) & Macro's must be enabled
  4. Windows PC · NOT a Mac!

No support is provided for customization or development of this Software

About Montage #back to top

Montage creates layout Worksheets for you to add images. It fits the Images to the Cell dimensions and uses Cell Formatting with Image transparency to make beautiful Montages. You can create "A4", "A3" or Custom Worksheets, ready to Print or Save as PDF. Measurements are in "CM" or "INCH" and you can choose the Image size, the Cell Shape, the Border size and the Cell Format. You can embed the Images or Link the Images and apply Transparency to allow the Cell Format to come through underneath the Images. Montage includes standalone Code that you can use in your own Projects to select any number of Cells and Embed Images

Features include:

  • * Creates a Layout Worksheet of a chosen size to fit a number of Images
  • * Allows you to Embed or Link Image
  • * Allows you to use Image Transparency
  • * Choose the Paper size and Orientation, the Border size and Cell Formatting
  • * The Download includes Standalone Code to use in your own Projects

Getting Started #back to top

The download File

Open the Montage.xlsm File and familiarize yourself with all of the settings

Quick Steps

Let's create a simple "A4" Worksheet with 4 x 10cm Embedded Images, a small Border and Image Transparency. This will be ready to Print. Start by adjusting the Settings if required as shown below. Ensure that the 'Recommended' RadioButton is selected. By selecting the Cell Shape as 'Square' Montage will decide how best to fit these to the "A4" Paper size and Portrait Orientation. It chooses to fit 4 Images 10cm as 2 Horizontally and 2 Vertically. You can leave the Cell Format as the default Formatting

Montage Getting Started 1 Image

Now ensure that you select Embed Images and Image Transparency

Montage Getting Started 2 Image

Press the 'Create a Layout' Button to create the Worksheet. Excel will now prompt you to add the Images required. Browse to where your Images are stored and select 4. I selected 4 'Fashion' Images. When Montage has finished, press CTRL+P to bring up the Print Dialog. Montage has fitted the 4 10cm Images into an "A4" Worksheet. The result is shown below with the nice Cell Formatting coming through the Image Transparency

Montage A4 Image

Montage Settings #back to top

Montage Settings are adjusted on the 'Create a Layout' Worksheet. Here are all of the Montage Settings with a description of what they do and their default settings:

Page Layout
Measurement:			cm				units for how everything will be measured, default = cm
Paper Size:				A4				the paper size - adjacent Width/Height, default = A4
Orientation:			Portrait		which way up your document will be generated, default = Portrait

Cell Shape & Borders
Cell Shape:				Square			the Excel cell shapes that will be generated, default = Square
Size [cm]:				10				dimension of a single cell
Border [px]:			5				internal border size of a single cell
Apply Cell Format:		No				apply a Cell Format to all of the Cells, default = No

The Number of Images & Dimensions that fit your chosen Paper Size
Recommended:			(RadioButton)	system recommended settings
Custom:					(RadioButton)	your own custom settings.  Important!: Row Heights must be <=14 cm

Miscellaneous Settings
Embed Images:			Yes				will embed any images selected as opposed to maintaining a link to the Filename and Filepath of the image (linked images will not travel with this Workbook, but selecting 'No' will dramtically reduce the Workbook Size), default = Yes
Add Images:				Yes				will run the AddImages() Subroutine upon document generation, default = Yes.  If No is selected, this Subroutine will apply all of the Worksheet & Print settings and then you can run the AddImages() Subroutine using ALT+F8 to add your own images
Move & Size Images:		No				enables the image or picture to move & size with Cells or to be free floating, default = No
Left Margin [px]:		0				print setting - the left margin, default = 0
Right Margin [px]:		0				print setting - the right margin, default = 0
Top Margin [px]:		0				print setting - the top margin, default = 0
Bottom Margin [px]:		0				print setting - the bottom margin, default = 0
Display Page Breaks:	No				will draw Page Breaks, default = No
Print Quality [DPI]:	600				sets the Print quality, default = 600
Black & White:			No				will only Print Black & White Images, default = No
Center Horizontally:	Yes				center all of the Images Horizontally.  Important!, set this to No if Margins are used, default = Yes
Center Vertically:		Yes				center all of the Images Vertically.  Important!, set this to No if Margins are used, default = Yes
Lock Aspect Ratio:		No				lock the aspect ratio - enables best fit of Image to prevent any distortion.  Important! - Images will not fit the entire Cells if this is set to Yes, default = No
Center if Locked:		Yes				will center the image if Lock Aspect Ratio = Yes, default = Yes
Gridlines:				No				toggles the Gridlines visibility for your document, default = No
Headings:				No				toggles the Headings visibility for your document, default = No
Default Folder:			(Button)		browse to set the default Folder for Montage to use when browsing for images
Select all Images:		No				will select all of the images added at the end of the process, default = No.  Please Note: if there are any existing image on the Worksheet they will also be Selected
Image Transparency:		Yes				make images Transparent, default = No, if set to Yes, then you need to specify the Transparency value.  Important! - if you set this to Yes, you must also set Embed Images to Yes!


Embedding & Linking Images #back to top

By default, Images are embedded into the Workbook whenever using Montage. You can change this setting to 'FALSE' to force Montage to only 'Link' Images. Linking Images, however, means that the Images will NOT travel with the Workbook if it is distributed

A word of warning when embedding Images - check the SIZE of the Image. Remember your Workbook will grow very large in size if you are adding 8 x 2MB Images!

Locking the Aspect Ratio #back to top

Locking the Aspect Ratio will force Montage to fit an Image within the Cell but it will not simply resize the Image to the Width and Height of the Cell, it will choose the best way to fit the Image inside the Cell, whilst maintaining its Shape ie. it will not DISTORT the Image. Take a look at the Image below with Lock Aspect Ratio set to "No" - it's not that distorted because the Cell shape is similar to the shape of the Image. Montage has fitted it perectly to the Cell dimensions

Montage Single Cell Image 1000px x 654px

If we resize the Cell to a square shape, let's see how the Image fits to the Cell with Aspect Ratio set to "No" - it doesn't look perfect, the Image is DISTORTED meaning that it looks like it has been stretched vertically, the Height is wrong and the people look thinner

Montage Single Cell Lock Aspect Ratio No Image 1000px x 654px

Now, take a look at the same Image but added to a Cell that is more square in shape with Lock Aspect Ratio set to "Yes" - see how Montage tries to do a best fit on the Cell for the Image whilst maintaining the correct aspect ratio. Montage knows it has to shrink the height of the Image in order to do a best fit due to the rectangular Image shape. It's not the same dimension as the Cell, but it still looks perfect. This is what happens when you Lock the Aspect Ratio and the Cells are not the same shape as your Images

Montage Single Cell Lock Aspect Ratio Yes Image 1000px x 654px

Tip: crop your Images if they are Landscape in shape ie. 6 x 4 Photographs so that they are square in shape if you want them to fit into a square Cell

Scaling Images #back to top

Freebie Code

Code has been added to Montage that can Scale the Images already created to completely fit the "A4" or "A3" Worksheets. After adding Images, you can run this Subroutine by pressing ALT+F8 and running the ScaleImages() Subroutine. I did not write this and the attribution is unknown. Please Note, this does not work with all Excel Versions and Printers!

' ScaleImages, will scale the Images to fit the Paper Size using (zoom %)  
Public Sub ScaleImages()
    Dim CurrView
    CurrView = ActiveWindow.View
    With ActiveSheet.PageSetup
        Application.ScreenUpdating = False
        .zoom = 100
        Do Until .Pages.Count > 1 Or .zoom = 400
            ActiveWindow.View = xlNormalView
            .zoom = .zoom + 1
            ActiveWindow.View = xlPageBreakPreview
        If .zoom <> 100 Then
            .zoom = .zoom - 1
        End If
        ActiveWindow.View = CurrView
        ActiveSheet.DisplayPageBreaks = False
    End With
    Application.ScreenUpdating = True
End Sub                            

Worksheet Tab Naming #back to top

Whenever you create a new layout, a new Worksheet will be added directly after the 'Create a Layout' Worksheet. Worksheet Tab Naming convention when 'Creating a Layout' is as follows:

Paper Size
Paper Orientation
Number of Horizontal Images
Number of Vertical Images
Count of the Number of Current Worksheets - 3 (the License WOrksheet, the Hidden System Worksheet
and the Create a Layout Worksheet

The last part of the Tab Name will generate a consecutive Integer number to ensure a unique Worksheet Name. Worksheet Tab Names will be truncated if >= 31 characters to 28 characters and "..." - this is unlikely unless a very large number of Worksheets are created. Here are a couple of examples of Worksheet Tab Names each created one after another:




Using the Standalone Code #back to top

To use the Standalone Code in your own Project, in the 'Montage.xlsm' File open the 'mdStandAloneCode' Code Module in the VBA Editor and select all the Code. Copy the Code to the Clipboard (CTL+C). Go to your own Project Code Module and Paste in the Code (CTL+V). Now Edit the ':: CONFIG' section of the Code for the available settings ie. 'MontageBorder', 'MontageLockAspectRatio' etc. The Cell Format is referencing Cell "G15". Change this if you want to use a specific Cell Format in another Cell. Scroll down until you come to the 'Private Sub Montage()' Subroutine and change the word 'Private' to 'Public'. Once you have set up these settings, switch to your Worksheet and press CTRL+F8 and run the 'Montage()' Subroutine to add your images (you can change the Name of this if you wish). In the example Image below I set 'MontageBorder' to 1, set 'MontageUseTransparency' to "Yes", set 'MontageApplyCellFormat' to "Yes" and changed 'MontageCellFormat' to Cell "G2" and added my Cell Formatting to "G2". I then added 3 Images which were resized to the exact Cell dimensions

Montage Standalone Code Image 1000px x 654px

Screen Shots #back to top

Single Cell with Bordered Image and Cell Format

Here is a Photo that has been added to a single resized Cell without using the 'Create a Layout' Button. I simply added a Cell Format and then ran the AddImages() Subroutine that comes with Montage to add the Photo

Montage Single Cell Image 1000px x 654px

Here is a Screen Shot of 2 Images added to an "A4" Worksheet in Landscape mode, ready to print or Save as PDF, centered both vertically and horizontally

Momtage 2 x 1 Landscape Image 1000px x 654px

The Image below is a Letter "A" filled with 12 small square Images, on A4, ready to print or Save as PDF, centered both vertically and horizontally

Momtage Letter A Portrait Image 1000px x 654px

The Image below is 4 Images on an A4 Layout, using a Soft Glow for the Images

Montage A4 Soft Glow on Images

The Image below is 2 Images on an A5 Layout, using Text Label overlays on the Images

Montage A5 Text Label overlay on Images

The Image below is 2 Images on an A5 Layout with Aspect Ratio Locked, using Text Label overlays on Fashion Images

Montage A5 Text Label overlay on Fashion Images

The Image below is 2 Images on an A5 Layout, ready to print or Save as PDF, centered both vertically and horizontally

Montage A5 Portrait Image

The Image below is a Letter "A" filled with 12 small square Images, on A4, ready to print or Save as PDF, centered both vertically and horizontally

Momtage A4 4x5 Portrait Image 1000px x 654px

Videos #back to top

Video of Creating a Montage on A4 for 4 Images

Here I run through some of the settings for Montage and create 4 Images with Cell Formatting and with/without locking the aspect ratio

Where do you get all of the Images used in the Montage Screen Shots?

You can download lots of Free to use Images from

Can I create Alphabet Letters?

You can create basic Letter shapes for Cell squares and populate these with Images using Montage, however I also have another Project coming soon entitled Montage Alphabet which will let you create Letters in Upper and Lower Case in different sizes and allow you to rotate them

Support #back to top

Please remember you have purchased very affordable Software and you have not paid for a full-time Software design agency - I am but one man. Occasionally I may help with small tweaks, but these requests will be put on a much lower priority due to their nature. You have not PAID for Support, Support is 100% optional and I provide it for your convenience, so please be patient, polite and respectful

Support (limited) for my Software includes:

* Responding to questions or problems regarding the Software and its features
* Fixing valid (replicated) bugs and reported issues for the VERSION I HAVE WRITTEN

Software support does not include:

* Customization and installation services
* Support for third party software or ANY kind of development whatsoever

Before seeking support, please...

* Make sure your question is a valid Software Issue and not a customization request
* Make sure you have read through the documentation and any related video guides before asking support on how to accomplish a task
* Make sure to double check the Software FAQs or online documentation
* Ensure that you access to the VBOM is allowed and that Macros can run in Excel
* Make sure to provide 'proof of purchase' and state the name / version of the Software that you are having issues with when requesting support by Email or via Facebook

How to get Support

Contact Mark Kubiszyn on the Email address provided when you purchased the Software, including the Order Number
Contact via our Facebook Page - remember to be patient, if there has been an issue with your download, I will always respond within 48 hours and will Email you the File directly if neccessary or via Messanger. For other issues the response time may be considerably longer and I may choose to respond to specific questions only (as is my right), depending on what has been asked

Version History (Changelog) #back to top

You can find the version history in the Code Module for any Macro-enabled Software or read more information below. The latest Version is always shown first


19.03.2020 (Version 1.1) 

Removed the License Sheet as it was pretty much just decoration and transferred the License information and Help links to the 'Create a Layout' Sheet
Restyled the 'Create a Layout' Sheet to show the Calculations and the Editable Cells as it was a little confusing which Cells you could enter a value into or select from a Drop-down
Added the ability to Enter values into the Width and Height Boxes when Custom is Selected for the Paper Size 
Added new Paper Sizes to the 'System' Sheet in cm and inches to include A5 and US Letter
SHBrowseForFolder and SHGetPathFromIDList do not work correctly in 64bit Excel - replace using a generic Function ShellGetFolder
Remove the Module with the Standalone Code
Changed the Error Handling Code for the AddImages_ Subroutine
Capture the Print Quality DPI setting when the setting chosen by the user is not allowed as it is not in the Print Quality Drop-down combo of the Page Setup when Printing
Add the ability to Format Headers and Footers prior to processing with specific Formatting Codes
Add a Prototype Layout Selection to quickly change the CORE settings for Aspect Ratio, Embedding Images and Transparency
Added the ability to use Label overlays with Text and transparency
Rubberducked! using Version


01.10.2018 (Version 1) released