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.

Please Login or Register  to view this content.

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

That would work fine. Typically a person would probably sign off on 4 or five items at a time.

I'm open to suggestions, especially a quick and easy way to add new users. I assume each person can have their signature saved in the same path on their local machine, this form will reside on a network drive and they will open it locall. That is not a problem, I will just have to teach someone to add the password and the path to the signature in the code when an employee comes or goes.