Security Watermark

[MattGu]

Hi Forum,

I am looking to see if it is at all possible for a worksheet sitting on a network to have a Logo/Symbol or something similar on the front sheet that, while the worksheet is being used on the network the Logo/Symbol is visible. Should that worksheet leave the network ie, emailed out, saved on a USB or similar the Logo/Symbol is lost.

This intention is that if the Logo/Symbol is missing then it is evident that the worksheet is no the original.

I trust that makes sense?

Thank you
Matt

[Marc L]

Hi,

the procedure should obviously load the logo from the workbook path
so when the sheet is located on a local drive the logo file is missing …

[MattGu]

Is it possible to break/remove the "finding" path when it leaves the network, so should it find its way back on to the network it still identifies itself as not the original document?

Cheers
Matt

[Marc L]

As I wrote the VBA procedure must load the logo from the workbook path
so if the workbook is not located on the network but on a local drive the procedure can't o b v i o u s l y find the logo !
The procedure can be the Workbook Open event for example, whatever …

[Marc L]

And before saving the workbook just delete the logo …

[MattGu]

Thank you

Regards
Matt

[Marc L]

You can use the Dir VBA function to check if the file exists in the workbook path …

[6StringJazzer]

VBA is not required to do this. See attached file. You will not see the logo. To see the logo, copy B5 and paste-values into B9.

Insert the logo image in Sheet2, in cell A1. I used a simple shape.
Add the ShowLogo named formula. This named formula returns the cell with the logo image if the current file location matches the desired file location shown on Sheet1. You can move both of these around. You may want to put them both in a hidden (or VeryHidden) sheet.
Insert any image file into Sheet1. Click on it. Type "=ShowLogo" into the formula box.