Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-11-2016, 08:52 AM
ryan1878 ryan1878 is offline Creating watermark macro for 400 staff Windows 8 Creating watermark macro for 400 staff Office 2013
Novice
Creating watermark macro for 400 staff
 
Join Date: Jul 2016
Posts: 1
ryan1878 is on a distinguished road
Default Creating watermark macro for 400 staff

Hi

I am currently setting up a tab in word 2013 that houses numerous macros to enable all staff to quickly enter what they need into legal documents.

I am however, having huge difficulty with inserting watermarks. As soon as I close the template down the macro breaks. This is an example of what I have so far. The watermark is an image, saved in a folder all staff have access to. The following macro should place PREP as a watermark.

Sub PREP()
'
' PREP Macro
'
'
ActiveDocument.Sections(1).Range.Select
ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader
Selection.HeaderFooter.Shapes("WordPictureWatermar k").Select
Selection.Delete
ActiveWindow.ActivePane.View.SeekView = wdSeekMainDocument
ActiveDocument.Sections(1).Range.Select
ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader
Selection.HeaderFooter.Shapes.AddPicture(FileName: = _
"E:\IT\MS Office 2013\PREP Watermark.png", LinkToFile:=False, _
SaveWithDocument:=True).Select
Selection.ShapeRange.Name = "WordPictureWatermark"
Selection.ShapeRange.PictureFormat.Brightness = 0.5


Selection.ShapeRange.PictureFormat.Contrast = 0.5
Selection.ShapeRange.LockAspectRatio = True
Selection.ShapeRange.Height = CentimetersToPoints(14.34)
Selection.ShapeRange.Width = CentimetersToPoints(15.92)
Selection.ShapeRange.WrapFormat.AllowOverlap = True
Selection.ShapeRange.WrapFormat.Side = wdWrapNone
Selection.ShapeRange.WrapFormat.Type = 3
Selection.ShapeRange.RelativeHorizontalPosition = _
wdRelativeVerticalPositionMargin
Selection.ShapeRange.RelativeVerticalPosition = _
wdRelativeVerticalPositionMargin
Selection.ShapeRange.Left = wdShapeCenter
Selection.ShapeRange.Top = wdShapeCenter
ActiveWindow.ActivePane.View.SeekView = wdSeekMainDocument
End Sub
Any help on what I am doing wrong would be greatly appreciated. I have 5 of these to create

Thanks
Ryan
Reply With Quote
  #2  
Old 07-13-2016, 02:45 AM
DougMVP DougMVP is offline Creating watermark macro for 400 staff Windows 7 32bit Creating watermark macro for 400 staff Office 2010 32bit
Advanced Beginner
 
Join Date: Nov 2013
Posts: 50
DougMVP will become famous soon enough
Default

Try

Code:
Dim WM As Shape
With Selection.Sections(1).Headers(wdHeaderFooterPrimary)
    If .Shapes.count > 0 Then
        .Shapes(1).Delete
    End If
    Set WM = .Shapes.AddPicture(filename:="E:\IT\MS Office 2013\PREP Watermark.png")
    With WM
        With .PictureFormat
            .Brightness = 0.5
            .Contrast = 0.5
        End With
        .LockAspectRatio = True
        .Height = CentimetersToPoints(14.34)
        .Width = CentimetersToPoints(15.92)
        .WrapFormat.Type = 5
        .RelativeHorizontalPosition = wdRelativeVerticalPositionMargin
        .RelativeVerticalPosition = wdRelativeVerticalPositionMargin
        .Left = wdShapeCenter
        .Top = wdShapeCenter
    End With
End With
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating watermark macro for 400 staff help creating macro tingker Word VBA 4 01-08-2015 08:58 PM
Creating watermark macro for 400 staff Need Help Creating Macro rsrasc Word VBA 4 03-28-2014 01:31 PM
Creating watermark macro for 400 staff Project as a Staff-tracking Tool Kerry Project 1 03-01-2012 02:46 PM
creating macro steveb Word VBA 0 08-14-2010 01:29 AM
Using MSP to predict staff resource jarvo273 Project 0 05-13-2010 04:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft