Add Watermark to Excel VBA

To add a watermark (or background image) to an Excel sheet using VBA, follow these steps:

Step 1: Prepare the watermark image

1. Ensure the image you want to use as a watermark is ready and accessible on your computer.

Step 2: Add the VBA Code

1. Open your Excel file.
2. Press Alt + F11 to open the VBA editor.
3. In the VBA editor, click Insert > Module to add a new module.
4. Copy and paste the following code into the module:

Sub AddWatermark()
    Dim ws As Worksheet
    Dim img As Picture
    Dim imagePath As String
    ' Specify the full path of your image (example: C:\Users\Username\Documents\watermark.png)
    imagePath = "C:\Path\To\Your\Image.png"
    ' Select the active sheet
    Set ws = ActiveSheet
    ' Insert the image as a watermark (background)
    Set img = ws.Pictures.Insert(imagePath)
    ' Adjust image properties to fit the sheet and send it to the back
    With img
        .ShapeRange.LockAspectRatio = msoFalse
        .Width = ws.PageSetup.PageWidth
        .Height = ws.PageSetup.PageHeight
        .Top = 0
        .Left = 0
        .ZOrder msoSendToBack  ' Send the image to the back
        .TransparencyColor = RGB(255, 255, 255)  ' Optional: make the image's background transparent if applicable
    End With
End Sub

Step 3: Run the Code

1. Modify the imagePath variable in the code to the actual path of your image.
2. Close the VBA editor by pressing Alt + Q.
3. To run the code, press Alt + F8, select AddWatermark, and click Run.

Code Explanation:

• The code inserts the specified image as a background on the active sheet and adjusts its size to cover the entire page.
• The ZOrder method sends the image to the back of the sheet, making it appear like a watermark.
• The TransparencyColor option is used to make the background of the image transparent if necessary.

Step 4: Save the File

• Once the image is added as a watermark, save your Excel file.

Note:

This watermark will only be visible within the Excel sheet view. It will not appear in printouts unless you modify the print settings (such as adding the image to the header or footer). If you want the watermark to also appear on printed pages, you can insert the image into the header or footer instead.