VBA makes make doc read only but user's can still copy and paste images off of it.

J

Josh

I created a form template that once the user finishes filling out
saves itself on a network drive. My problem is that during the
process, depending on what the user clicks on, a certain image will
appear on the form. If yuou open the form after the VBA has ran you
have to put in a password if you want to modify the document in anyway
but this does not stop them from coping and pasting the image
somewhere else. It is very important that this image is locked down.
Any help is great!

The code that inserts the image:

ActiveDocument.Bookmarks("sig").Range.InlineShapes.AddPicture _
FileName:="C:\PhyData\" & UserForm1.ComboBox2 & ".JPG", _
LinkToFile:=False, SaveWithDocument:=True


The code that locks the document:

Sub ReadOnlySet()
If ActiveDocument.ProtectionType = wdNoProtection Then
ActiveDocument.Protect wdAllowOnlyReading, True, "123"
Else
ActiveDocument.Unprotect "123"
ActiveDocument.Protect wdAllowOnlyReading, True, "123"
End If
ActiveDocument.Save
End Sub
 
G

Graham Mayor

If you allow someone to see a document they can do what they like with it.
The password for forms functions only stops the *original* from being
edited. It does not stop copies being edited.There is no way to prevent
copying of *anything* you allow someone to see (or hear). If you were able
to do that the media industry alone would reward you beyond your wildest
dreams.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
G

Graham Mayor

There is *no* possibility of a solution. That's the whole point. If you
allow someone to view it, it can be copied. The only way to prevent it from
being copied is not to let anyone see it.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top