copy to clipboard help

[simon26r]

Hello All

Can anyone please help me? I have a formula ="<a title="""&H14&""""&" href""http://www."&I14&""""&">"&H14&"</a>"

Is there a way to add a simple code so that if i click on the cell it automatically copies to the clip board without having to press control + C

Thank you

[rcm]

yes there is... using the worksheet automated subs

I suggest to use the rightclick for this....

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Selection.Copy
End Sub

[simon26r]

Sorry for being stupid but i don't understand how to do that

[rcm]

OK I try to walk you thru it.

Click the developer tab
Click the view code
There will be to drop down lists
expand the left one
choose worksheet

go to the right list choose beforerightclick

insert: selection.copy

go back to the spreadsheet and save it

[simon26r]

now im going to be really silly but i cant even find the developer tab MS Excel 2010

ok found it now

for anyone who needs to know

1.Click the File tab.
2.Click Options.
3.Click Customize Ribbon.
4.Under Customize the Ribbon and under Main Tabs, select the Developer check box.

[simon26r]

thank you, I have that working now but is there a way to get it to just copy say colum D

[rcm]

yes...

mind you that column "D" is column #4

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
if target.column=4 then Selection.Copy
End Sub

[simon26r]

Hi. I have tried this and it worked but when i changed to just a column 7 for G it does not work for me
copy.jpg