Double click a certain cell to insert a signature image

**SpringLily** · 09-27-2011, 10:35 AM

Hi, there
I would like to insert a signature image into a certain cell by double click it. How do I code it to make it happen?
Thanks.
Regards,
Lily.

**Mordred** · 09-27-2011, 10:43 AM

In your worksheet module insert this code and then change your path and picture name accordingly (as well as the target address)

Please Login or Register  to view this content.

**SpringLily** · 09-27-2011, 10:48 AM

Thanks. Mordred.
If the cell is a defined name, how do I modify the code to make it to work? Sorry to bother you again. Regards, Lily.

**Mordred** · 09-27-2011, 10:51 AM

Hi Lily, you are no bother. I've slightly changed the code

Please Login or Register  to view this content.

**SpringLily** · 09-27-2011, 10:57 AM

Thanks again. :-)
There are quite a few sheets with same name defined in each sheet. Will it benefit if I change the event to workbook? How do change it?
Regards,
Lily.

**Mordred** · 09-27-2011, 11:08 AM

Hi Lily, in ThisWorkbook module, place the following code

Please Login or Register  to view this content.

**SpringLily** · 09-27-2011, 11:40 AM

Thanks, Mordred. It works perfectly. :-)

**Mordred** · 09-27-2011, 11:43 AM

You're welcome

. Thanks for the rep.

Double click a certain cell to insert a signature image

LinkBack

Thread Tools

Rate This Thread

Display

Double click a certain cell to insert a signature image

Re: Double click a certain cell to insert a signature image

Re: Double click a certain cell to insert a signature image

Re: Double click a certain cell to insert a signature image

Re: Double click a certain cell to insert a signature image

Re: Double click a certain cell to insert a signature image

Re: Double click a certain cell to insert a signature image

Re: Double click a certain cell to insert a signature image

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions