MS Word: Remove watermark from all Word pages using VBA

Category: MS WordTags: , ,

You can create watermark in MS Word document by going to Format Menu > Background > Printed Watermarks… Here you will be able to set Text Watermark in each page. Now if you want to remove the watermark from all pages, use the following VBA script.

Dim section As Word.section
Dim pheadertype As Long
Dim hdr As Range
Dim sp As Shape
Dim str As String
For Each section In ActiveDocument.Sections
   With section
      Set hdr = .Headers(wdHeaderFooterFirstPage).Range
      For Each sp In hdr.ShapeRange
         str = sp.Name
         If InStr(str, "PowerPlusWaterMarkObject") > 0 Then
            sp.Visible = msoFalse
          End If
       Next
       Set hdr = .Headers(wdHeaderFooterPrimary).Range
       For Each sp In hdr.ShapeRange
          str = sp.Name
          If InStr(str, "PowerPlusWaterMarkObject") > 0 Then
              sp.Visible = msoFalse
          End If
        Next
    End With
 Next

Share

11 comments

Your email address will not be published. Required fields are marked *

  1. Alana says:

    Wow and thanks Vishal; very much appreciated! I’m new to VBA in Word and Excel, and this was perfect in Word! Haven’t done macros in over 2 decades and needed to jump back on it.