Adding watermarks in Word using Excel/VbA

**aman1234** · 10-31-2013, 11:14 AM

Hi Guys

I want Excel / VBA code that will help me in inserting watermarks on Word document. I have a userform in excel and when the user click on a button then it should insert watermark in the word document.

I hope anyone can help me in this

Thanks

**macropod** · 10-31-2013, 09:31 PM

Please post the code you're using to automate the Word document.

FWIW, watermarks in Word are simply content inserted into the page header.

PS: When posting code, please use the code tags. They're on the 'Go Advanced' tab.

**aman1234** · 11-05-2013, 08:16 AM

Hi

I am using the following code. It opens a word document but it doesn't display a watermark. Any help would be much appreciated.

code behind Form on Button :

Please Login or Register  to view this content.

Code Behind Module :

Please Login or Register  to view this content.

**macropod** · 11-05-2013, 06:13 PM

Because you're using late binding, you need to either declare all the Word constants or use their values directly. You also need to pass the application and document references to your function.

Try:

Please Login or Register  to view this content.

PS: You'll also see that my code doesn't reference your 'BackGroundPicture' bookmark. Rather, it references the header directly. That way, it doesn't matter whether the bookmark gets deleted.