Insert signature image - password protected

I am trying to create a monthly checklist
When an item on the checklist is completed, I want to insert a signature image - (.jpg file)

Is there a way to:

Prompt for a password when the user tabs into a cell

and

Based upon the password, insert the corresponding signature image.

Example:

John Doe tabs into a cell, it prompts for his password, he enters the password and the image of his signature appears.

Jane Doe tabs into a cell, it prompts for her password, he enters the password and the image of her signature appears.

A person should not be able to cut and paste the signature image after it is inserted.
There maybe multiple signatures on the sheet through the course of a month.

Well, that works great and I can work with it... (I am just learning this...)

Now, can the cell be protected so the image cannot be copy and pasted?

and

Is there a way to give a message when an incorrect password is used?

Will the image be imbedded so it will appear on other computers that do not contain the image file?

Hi

1) The only way I know to protect the picture is to protect the sheet. If you do that, then you will have to include the protection on/off in your code.

2) I've enhanced the code to (a) include an error message and (b) to remove any previous entry before bringing in a new one.

Private Sub CommandButton1_Click()
  pic = ""
  On Error Resume Next
  Set oldpic = ActiveSheet.Pictures("Sign")
  On Error GoTo 0
  If Not IsEmpty(oldpic) Then oldpic.Delete
  
  Select Case TextBox1.Text
    Case "fred"
      pic = "C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Blue Hills.jpg"
    Case "sam"
      pic = "C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\sunset.jpg"
    
  End Select
  If pic = "" Then
    MsgBox "Incorrect Password"
    TextBox1.Text = ""
    TextBox1.SetFocus
  Else
    ActiveSheet.Pictures.Insert(pic).Select
    Selection.Name = "Sign"
    Range("D3").Select
    Unload Me
  End If
  
End Sub

3) Ahhh... Don't know. How about trying it. If it doesn't copy across, then perhaps build a sheet that contains all the images (protect, hidden etc) and then the code could copy it in from the "images" sheet. I would imagine that it would add to the file size though....

rylo

rylo, what you have given me is very much what I need but I need to add a little more functionality.

I have attached a sample sheet as an example... (with no code)

I need to have a check box in one column, insert the current date in the next column.

Furthermore, I would like the person to be able to check multiple boxes on various lines and then, upon clicking an "Insert Signature" Block, the corresponding lines be populated with the signature image.

I need to protect the signature image column, I have had no success on that.

Hi

Rather than having a button, how about using an event from the checkbox. When it is selected, it asks for the password. If this is OK, then it populates the next column with the current date / time and inserts the signature. You should be able to adapt the existing code to do that.

Means that each one is done individually, but as you seem to have different names, then I imagine that would be the preferred option. If the same user does more than 1 item then they would have to go through the same thing for each click.

How does that sound?

rylo