Click to copy

[sms2luv]

I have made some shapes and named them like google, MSN...
I want that once I click the shape, hyperlink should be copied to clipboard.

I don't want the link to open like normally we do with hyperlink.

Let's say when I click on Google shape, http://google should be copied to clipboard.
Need help as to where I can put the hyperlink, to get copied

 

[paulcherianc]

Can you please provide a sample workbook

 

[paulcherianc]

I have created a sample for you. Just try this.

 

[paulcherianc]

Either you can encode the hyperlinks on the VBA or inside any excel sheet.

 

[sms2luv]

Attaching example

 

[paulcherianc]

Try this

 

[sms2luv]

Wow, this did the work I wanted.