b PRINTED WATERMARK for Microsoft Excel

What's new   Download   Home  Ads

This utility is a COM add-in or add-in (.xla) programmed in Microsoft® Visual Basic® for Application (VBA) that inserts printed watermark in sheets of Microsoft® Excel® 2002(XP) or later. It is not a workaround. It functions equal or better than the "Printed Watermark" command of the Word. Moreover inserting pictures, it permits still to position, change colors, change size, copy between sheets of opened and closed workbooks, and much more.

Watermark normally is a ghosted text picture that is behind the content on the printed page. This is often used to indicate that a printed document is to be treated as specially, such as DRAFT, URGENT or CONFIDENTIAL. Pictures saved in several file formats (gif, jpg, bmp, etc.) can too be used to improve the aesthetics and to personalize printed documents.

It consists of only one file, the ExcelWatermark.dll, which is about 460 kb in size and can be installed automatically. Except for the DLL, no another setting is saved in the Microsoft® Windows® Register. Its setting is saved in ExcelWatermark.ini file that is created and maintained by the proper utility. You can uninstall it totally and automatically, leaving no mess on your Windows Register or disc.

Note: To simulate the watermark, this utility handles along the page the picture of the left header position that is one of the Excel page setups. There is another utility on the site, the Page Setup Manager for Excel, which manages all the Excel page settings. It, beyond restores and copies page settings between sheets including header and footer picture settings, also supports to handle all these pictures along the page, making it possible to simulate up to three watermarks and up to three stampmarks by page or nine watermarks and nine stampmarks by sheet on the Excel 2007, 2010, or 2013. It also provides a set of functions in VBA so that all the features available to interface users may also be available to VBA project developers.

Following items in this page:




Deleting Inserted Watermarks


- The watermark can be made from any picture saved in a file format that is recognized by Excel (e.g., *.emf; *.wmf; *.jpg; *.jpeg; *.jfif; *.jpe; *.png; *.bmp; *.dib; *.rle; *.gif; *.bmz; *.gfa; *.emz).

- Text or phrases, such as DRAFT, CONFIDENTIAL, URGENT, can be inserted as a watermark as well.

- A picture can be made from any selection on any open sheet and inserted as a watermark as well. The selection can be a cell, a cell range, an object, or a group of objects over the sheet (e.g., a chart, WordArt, a diagram, a shape, or AutoShape). (New in version 2.0 released on 10/17/10)

- The picture can be centered in three different area options: the total area of the paper, the area under cell sheet plus the header and footer area, or just the area under the cell sheet. (Idem)

- In Excel 2007, 2010, or 2013, after the picture is centralized, it can be optionally anchored on the left margin of the print area to follow any changes in its size. (Idem)

- In Excel 2007, 2010, or 2013, different watermarks can be inserted on the first page, on the odd pages, or on the even pages.

- You can adjust the color, brightness, contrast, position, and size of the picture; set up the page (e.g., change the paper size or margins); change the printer; and see a print preview without the need to exit from the inclusion forms.

- The printed watermark picture can also be moved or enlarged beyond the limits of the paper (i.e., create an oversized image) if so desired.

- You can insert a watermark on any of the sheets in any open workbooks, copy from one sheet to any other sheet in any open workbook, or copy to all other sheets at once in the same run.

- Without exiting the form, the copy process can advance more to create new sheets and workbooks, close and open one or a batch of workbooks already saved on the disk.

- When copying the watermark to other sheets, some other page and print settings can be copied as well if desired.

- A watermark previously inserted can be duly deleted thru the utility or thru the Excel menu, see how soon below

- After installed, the utility is called from Excel Format Menu > Sheet Submenu > Printed Watermark Command or, on the Excel 2007, 2010, or 2013, from Ribbon > Page Layout Tab > Watermark Button.


Tested in Excel for Windows, versions 2002(XP), 2003, 2007, 2010 (32-bit), 2013 (32-bit), 2016 (32-bit), and 2019 (32-bit) in MSI-based and Click-To-Run installations of Office 365™ cloud-based services.


Download the English version now

You also can download from this mirror site

Last update: 03/25/2022 - 871.1kb

Freeware based in this License Agreement

Note: The above link downloads the installer and uninstaller package programmed in VBA in a XLS duly converted to EXE by the XLtoEXE to make the installation easier for macro and Microsoft® Windows® laymen; however, if you're an expert and for some reason prefer an installer and uninstaller package in open ZIP format, click here. With this zip package you can install it in three ways: (1) Simply initiate the Install.exe that loads the same XLS in Excel without macro alert; (2) Extract the entire package to a folder and initiate the XLS, enabling the macros in Excel and using 123 as password, or (3) Install the DLL manually.




Deleting Inserted Watermarks:

Watermarks inserted thru this utility can be deleted too thru the Excel menu that way:

- Open the Workbook in the Excel

- Activate the Sheet with the Watermark to delete

- On the Excel File menu, click Page Setup command or, on the Excel 2007, 2010, or 2013, Ribbon > Page Layout Tab > Page Setup Button

- In the Page Setup dialog box, click Header/Footer tab

- In the Header/Footer tab, click Custom Header button

- Click in the Left section, select &[Picture] and then press Delete key.

About Add-in (.xla):

Temporarily unavailable.


More information







Visitas acumuladas em todas as páginas:
Visitas hoje só nesta página: